Help Center> Data Admin Service> Getting Started> Cloud DBA> Step 2: Accessing Cloud DBA
View PDF

Step 2: Accessing Cloud DBA

Procedure

  1. In the navigation pane, choose Cloud DBA to go to the Instance Overview page.

    Figure 1 DAS homepage

  2. Locate the card of the instance you want to view and click Details.

    Figure 2 Cloud DBA instance overview page

    In the following example, SQL Explorer is used to show how to use cloud DBA functions. For more information, see CloudDBA.

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

    Figure 3 SQL Explorer
    • 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.

    Figure 4 SQL Statements
    • 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 view them on your local PC.
      Figure 5 Export

  5. Click the SQL Templates tab.

    Figure 6 SQL Templates
    • By default, the SQL statement executions in the last 15 minutes 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.

    Figure 7 SQL template details

  7. Diagnose again and view the diagnosis details.

    Figure 8 Diagnosis details

  8. Click the SQL Statement Types tab.

    Figure 9 SQL Statement Types
    • On the SQL Statement Types tab page, six types of frequently used SQL statements such as INSERT, DELETE, and UPDATE are analyzed and displayed. By default, the SQL statement executions with the last 15 minutes will be displayed. You can also specify a time range for statement display.

  9. Click Details in the Operation column to view SQL details.

    Figure 10 SQL details

Parent topic: Cloud DBA