Step 2: Go to Intelligent O&M

Procedure

1. In the navigation pane, choose Intelligent O&M. On the Instance Overview page, click Synchronize Instances and then click Refresh.
   

   Instance synchronization is an asynchronous process, which generally takes several minutes to complete.

2. Locate the instance you want to view and click Details.
3. On the displayed page, choose SQL > SQL Explorer.
   

   • Enable DAS SQL Explorer must be toggled on so that the system can collect and analyze full SQL statements.
   • With Enable DAS SQL Explorer toggled on, the instance performance loss is within 5%.

4. Click the TOP SQL tab, select Last 1 hour, Last 3 hours, or Last 6 hours or specify a time range spanning no more than one day, to view the top SQL statements executed.
   

   Execution Duration Distribution displays the distribution of execution durations for all SQL templates in a specific period of time. There are four execution duration ranges. The system calculates how many times the SQL templates are executed in each execution duration range. If you select Last 1 hour, the execution durations are calculated every 10 seconds. If you select Last 6 hours, the execution durations are calculated every 1 minute. If you select a time range longer than 6 hours, the execution durations are calculated every 5 minutes. The execution duration ranges of SQL templates are as follows:

   • < 100 ms
   • 100 ms—500 ms
   • 500 ms—1s
   • > 1s

5. Select By instance or By node. If you select By node, the execution duration distribution of the primary node is displayed by default. To view the duration distribution of other nodes, click Change Node.
6. Use either of the following method to view execution duration details, such as average execution duration, total duration, average lock wait duration, and average scanned rows.
   • Hover your mouse at any point in time on the graph to view top SQL templates at that time.
   • Specify a time range using your mouse on the graph, and you will see top SQL templates used during that time range.

7. In the SQL template list, locate a SQL template and click Details to view the total execution times, average rows scanned, average execution duration, and the like.