This topic describes how to view the information about database calls of an application. You can view general information about database calls and the details of SQL calls, exceptions, call sources, and traces.

Prerequisites

Your application is monitored by Application Real-Time Monitoring Service (ARMS). For more information, see Overview.

Procedure

  1. Log on to the ARMS console .
  2. In the left-side navigation pane, Select Application monitoring > Applications .
  3. In the top navigation bar of the MNS console, select the region where your cluster is deployed.
  4. Log on to the Applications Page, click the application name.
  5. In the left-side navigation pane, click Database Calls.
  6. On the page that appears, select a database and set the time period.
    Database calls
  7. After you complete the settings, perform the following operations:
    • On the Overview tab, view general information about database calls of the application.
    • Click the SQL Analysis tab to view the SQL analysis of the application.
    • Click the Exception Analysis tab to view the database call exceptions of the application.
    • Click the Call source tab to view the information about the applications that call the database of the application.
    • Click the Trace Query tab to view the traces of the application.

Overview

The Overview tab displays general information about database calls of the application. You can view the call topology, number of requests, response time, number of errors, result size, and performance.

Overview
Optional:On the Overview tab, perform the following operations:
  • Click the Zoom In icon icon or scroll the mouse wheel up to zoom in the topology.
  • Click the Zoom Out icon icon or scroll the mouse wheel down to zoom out the topology.
  • Click the Refresh icon icon to restore the topology to the default size.
  • Click the Adjust Topology icon icon to adjust the topology size to fit the page.
  • Move the cursor over the statistics chart to view the statistics.
  • Select a period of time to view the statistics for the specified period.
  • Click chartIcon to view the statistics of the metric in a certain time period or compare the statistics of the same time period on different dates.
  • Click codeIcon to view the API details for this metric.
  • Click alertIcon to create an alarm for the metric. For more information, see Create an alert.

SQL analysis

The SQL Analysis tab displays the column chart for the number of SQL calls, the time series curves for the response time, and a list of SQL statements that are executed in the database.

SQL analysis
Optional:On the SQL Analysis tab, perform the following operations:
  • Move the cursor over the statistics chart to view the statistics.
  • Select a period of time to view the statistics for the specified period.
  • Click chartIcon to view the statistics of the metric in a certain time period or compare the statistics of the same time period on different dates.
  • Click codeIcon to view the API details for this metric.
  • To view the SQL call statistics of an SQL statement, click Invocation Statistics in the Actions column of the SQL statement.
  • To view the traces of an SQL statement, click Trace Query in the Actions column of the SQL statement.

Exception analysis

The Exception Analysis tab displays the information about exceptions of the database.

Exception analysis
Optional:On the Exception Analysis tab, perform the following operations:
Note To filter exceptions, perform the following steps: In the left-side navigation pane, click Application Settings. On the page that appears, click the Custom Configuration tab. In the Advanced Settings section, set the Whitelist field.
  • Move the cursor over the statistics chart to view the statistics.
  • Select a period of time to view the statistics for the specified period.
  • Click chartIcon to view the statistics of the metric in a certain time period or compare the statistics of the same time period on different dates.
  • Click codeIcon to view the API details for this metric.
  • To view the statistics of an exception, click Invocation Statistics in the Actions column of the exception.
  • To view the details of an exception, click Details in the Actions column of the exception.

Call sources

The Call source tab displays the information about the call sources of the database.

Call sources
Optional:On the Call source tab, perform the following operations:
  • To view the information about an application that calls the database or the information about an API that is called, enter the application or API name in the search box and click the Search icon.
  • To view the traces of an API that is called by a call source, click view details next to the API.
  • Move the cursor over the statistics chart to view the statistics.
  • Click chartIcon to view the statistics of the metric in a certain time period or compare the statistics of the same time period on different dates.

Trace query

The Trace Query tab displays the traces of the database.

API name
Optional:On the Trace Query tab, perform the following operations:
  • To view all the traces of an API, enter the API name in the search box and click the Search icon.
  • To view the details of a trace, find the trace and click the trace ID in the TraceId column.
  • To view the logs of a trace, find the trace and click View Logs in the Actions column.