Help Center/ Data Admin Service/ User Guide (ME-Abu Dhabi Region)/ Getting Started/ Intelligent O&M/ Step 2: Switch to Intelligent O&M
Updated on 2023-03-28 GMT+08:00
View PDF
Share

Step 2: Switch to Intelligent O&M

The following uses a free instance as an example to describe basic operations of Intelligent O&M. If you want to set a free instance as paid, see Step 3: Set an Instance as Paid.

For differences between free and paid instances, see Billing.

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 no longer than one day, to view the top SQL statements executed.

    Execution Duration Distribution displays the distribution of the time required to execute all SQL templates in a specific period of time. There are four execution duration ranges. The system calculates execution times of the SQL statements in each execution time range. If you select Last 1 hour, the execution duration distribution is updated every 10 seconds. If you select Last 6 hours, the distribution is updated every 1 minute. If you select a time range longer than 6 hours, the distribution is updated 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, you can view execution duration distribution of the primary node. You can change node to view the duration distribution of other nodes. The primary node is selected by default.
  6. View execution duration details of top SQL templates with the following methods, 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.
    • Enable Custom Time Range and select a time range on the graph to view top SQL templates used.

  7. In the SQL template list, locate a SQL template and click Details to view the total execution times, average scanned rows, average execution duration, and the like.
Parent topic: Intelligent O&M