This topic describes how to use the performance insight feature to evaluate database workloads and find root causes of database performance issues based on provided charts. This makes databases more stable.

Prerequisites

The performance insight feature is available only for Apsara RDS and PolarDB databases.

Background information

The performance insight feature collects and analyzes data from the following sources:
  • If performance_schema is enabled for database instances, the performance insight feature collects and analyzes the data stored in performance_schema.
  • If performance_schema is disabled for database instances, the performance insight feature collects and analyzes the data of active sessions.

Procedure

  1. Log on to the DAS console.
  2. In the left-side navigation pane, click Instance Monitoring.
  3. On the Instance Monitoring page, find the instance that you want to view and click its ID.
  4. In the left-side navigation pane of the instance details page, click Performance Insight.
  5. On the Performance Insight page, click Enable Performance Insight.
  6. In the message that appears, click Confirm.
  7. On the Performance Insight page, you can manage your database and view the following information:
    • In the Performance Trend section, you can specify a time range to view the performance trends of the database. If you want to view the details of a specific performance metric such as CPU utilization, click Details in the upper-right corner of the performance metric section.
      Note The specified time range cannot exceed seven days.
    • In the Average Active Session section, you can select a session type such as SQL to view the corresponding trend charts. In this section, you can also view the multidimensional details of service loads for each session type. This helps you identify root causes of performance issues.