Database Autonomy Service:Performance Insight (New Version)

Billing

Performance Insight is a premium feature of DAS Economy Edition and Enterprise Edition V3. Instances in regions that support DAS Economy Edition and Enterprise Edition V3 are billed according to the activated edition.

• For regions supported by DAS Economy Edition and Enterprise Edition V3, see Supported databases and regions for each edition.

• For billing details of DAS Economy Edition and Enterprise Edition V3, see Billing details.

Function introduction

Procedure

1. Log on to the DAS console.

2. In the navigation pane on the left, click Intelligent O&M Center > Instance Monitoring .

3. Find the target instance and click the instance ID to open the instance details page.

4. In the navigation pane on the left, click Performance Insight.

5. If you have not activated Alibaba Cloud Managed Services, you see a prompt saying You have not activated O&M Service.. Click the Enable O&M Service button. On the Activate O&M Service page, select a Service Duration and click Activate.

6. On the Performance Insight tab, click Enable Performance Insight.

   If you have not enabled performance_schema as required, the console displays a Parameter Settings dialog box. Follow the on-screen instructions and click Configure to configure performance_schema parameters as described in Enable Performance Schema.

   Warning

   Modifying these parameters requires restarting the database instance. Perform this operation during off-peak hours and ensure your application has a reconnection mechanism.

   When you enable Performance Insight, the system automatically enables identification of tables with no traffic and indexes with no traffic.

   Important

   Starting April 11, 2023, Performance Insight includes identification of tables with no traffic and indexes with no traffic. Instances that enable Performance Insight after this date automatically enable this feature. For instances that enabled Performance Insight before April 11, 2023, you can manually enable Identification for Tables and Indexes with No Traffic in Service Settings.

7. On the Performance Insight page, you can use Display by Time Range, Display by Comparison, and Tables/Indexes view:

   • Display by Time Range:

     • In Quick View, select a metric (Resource Usage, Executions, Scanned Rows, Execution Duration, or Average Active Sessions), specify a time range, and view the trend chart for that metric.

       Note

       The end time must be later than the start time. You can view up to seven days of data from the past month.

     • Click Export to save SQL information locally.

     • Click Show to view trend charts for key metrics.

       Note

       Click Settings and select metrics to display in the Metrics section.

       In the Settings dialog box, the Metrics section includes: executions/errors, rows scanned/updated, logical reads, physical reads, average execution duration, number of temporary tables created, rows sorted, Select_Scan/Select_Range, and TOP 5 SQL trends. In the Column settings section below, select columns to show in the SQL analysis table, such as SQL ID, SQL template, database, time ratio, executions, average execution time, average rows scanned, average rows returned, table name, average lock duration, and CPU utilization. Click OK when done.

     • In the SQL list area, view detailed information about SQL statements.

       Note

       Click Settings and select statistical metrics to display in the list under Column Settings.

       • Click a target SQL ID to view trend charts for Resource Usage, Executions, Scanned Rows, and Execution Duration during the selected time range, along with SQL sample information.

       • Click Sample in the Actions column for a target SQL statement to view its sample information.

       • Click Throttling in the Actions column for a target SQL statement. On the SQL Throttling page, configure rate-limiting parameters. For details, see SQL throttling.

       • Click Optimize in the Actions column for a target SQL statement. In the SQL Diagnostic Optimization dialog box, view the diagnosis results.

         If you accept the recommendations, click Copy in the upper-right corner and paste the optimized SQL into your database client or DMS to execute it. If you reject the recommendations, click Cancel to end the diagnosis.

         Note

         DAS performs SQL diagnosis based on SQL complexity, table data volume, database load, and other factors. Diagnosis results may take more than 20 seconds to return. After diagnosis, the SQL diagnostics engine provides results, optimization suggestions, and expected benefits. Review the results to decide whether to apply the suggestions.

         You can also click Expert service to purchase Database Expert Service. This paid service provides professional support beyond standard ApsaraDB capabilities, including emergency response, health checks, performance tuning, mission-critical support, and data migration.

   • Display by Comparison: Select time points to compare and view comparison results for all SQL statements’ Resource Usage, Executions, Scanned Rows, and Execution Duration. You can also view detailed comparison results in the SQL list area below.

     Note

     Click Settings to select statistical metrics to display in the list.

   • Tables/Indexes: Set filter conditions to query Tables with No Traffic and Indexes with No Traffic that meet your criteria.

Disable Performance Insight

1. Log on to the DAS console.

2. In the navigation pane on the left, click Intelligent O&M Center > Instance Monitoring .

3. Find the target instance and click the instance ID to open the instance details page.

4. In the navigation pane on the left, click Performance Insight.

5. On the Performance Insight tab, click Service Settings, turn off the Feature Setting, and click OK. In the confirmation dialog box, click OK to disable Performance Insight.

   Disabling Performance Insight also disables identification of tables with no traffic and indexes with no traffic. You can also disable Identification for tables and indexes with no traffic is disabled. separately. After disabling this feature, DAS deletes data for tables and indexes with no traffic, along with their usage data.

   Important

   After disabling Performance Insight, DAS stops data collection and deletes all historical data, including data for tables and indexes with no traffic and their usage data.

References

Enable DAS autonomy features to automate remediation for database performance issues.

• Automatic SQL throttling

• Automatic SQL optimization

• Automatic fragment reclamation