Step 2: Access Cloud DBA

Procedure

1. In the navigation pane, choose Cloud DBA (Intelligent O&M) to go to the Instance Overview page.
2. Locate the card of the instance you want to view and click Details.
   Note

   In this example, SQL Explorer is used to show how to use cloud DBA functions. For more information, see Cloud DBA for RDS DB Instances.

3. On the displayed page, choose SQL > SQL Explorer.
   Note

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

4. Click the SQL Statements tab.
   Note

   • A maximum of 10,000 data records can be displayed on the SQL Statements tab page. To view more records, export the records for view. Columns such as execution duration, elapsed time, scanned rows, and lock wait are also provided. Additionally, SQL statements can be searched by multiple dimensions, including keyword, time range, and number of updated rows.
   • To view more records, click Export to create an export task. Click Export History to check whether the export task succeeded.
   • After the export succeeded, download the file and view the records on the local PC.

5. Click the SQL Templates tab.
   Note

   • By default, the SQL statement executions in the last 1 hour are displayed. You can also specify a time range as needed. Columns such as average duration, total duration, total executions, and average scanned rows are provided.

6. Click Details in the Operation column to view the SQL template details.
7. Click the SQL Statement Types tab.
8. Click Details in the Operation column to view SQL details.