SQL

This function monitors database access, including MySQL, Elasticsearch, and HBase. Collectors collect details about executed statements to help you locate performance problems in code.

1. Log in to the management console.
2. Click on the left and choose Management & Governance > Application Performance Management.
3. In the navigation pane, choose Link Trace > Metrics.
4. In the tree on the left, click an environment. Then click the SQL tab.
5. On the displayed page, select an instance to view its monitoring data.

Overview

Displays the number of database call errors, average duration, number of calls, and maximum duration of the selected instance.

SQL statistics

Monitors databases by SQL statement. The monitored metrics include the statement, number of calls, average duration, maximum duration, number of errors, number of slow SQL statements, slow SQL trace, and error SQL trace.

• Set the search criteria and click in the search box to filter instances.
• Click in the upper right corner of the list and select the target metric data.
• Click in the upper right corner of the list to export information. A maximum of 100 records can be exported.

Database statistics

Displays monitoring metrics by database, including the database, number of calls, average duration, maximum duration, and number of errors.

• Click a number in blue (such as those in the Calls or Avg RT (ms) column) to view more details.
• Set the search criteria and click in the search box to filter instances.
• Click in the upper right corner of the list and select the target metric data.
• Click in the upper right corner of the list to export information. A maximum of 100 records can be exported.