This topic shows you how to view the SQL analysis of an application.

Prerequisites

The Application Real-Time Monitoring Service (ARMS) agent is installed for an application. For more information, see Overview.

Procedure

  1. Log on to the ARMS console. In the left-side navigation pane, choose Application Monitoring > Applications.
  2. On the Applications page, select a region in the top navigation bar and click the name of the application that you want to manage.
    Note
    If the Java icon icon is displayed in the Language column, the application is connected to Application Monitoring. If a hyphen (-) is displayed, the application is connected to Tracing Analysis.
  3. In the left-side navigation pane, click Application Details.
  4. On the Application Details page, select an instance where the application is deployed, set the time period, and then click the SQL Analysis tab.
    SQL Analysis

SQL call statistics

The SQL Calls section displays the time series curve that indicates the SQL call statistics of the application in the specified time period.

Optional:In the SQL Calls section, you can perform the following operations as needed:
  • Move the pointer over a chart and view the detailed statistics.
  • Click the chart icon to view the statistics of the metric in a certain time period or compare the statistics of the metric in the same time period on different dates.
  • Click the code icon to view the API details of the metric.

SQL statement list

The SQL statement list displays all SQL statements that are executed in the application in the specified time period.

Optional:In the SQL statement list, perform the following operations as required:
  • To view the time series curve of the SQL call statistics of an SQL statement, click Invocation Statistics in the Actions column.
  • To view the traces of an SQL statement, click Interface Snapshot in the Actions column.

    For more information, see Query traces.