All Products
Search
Document Center

Performance Insight

Last Updated: Aug 06, 2020

DAS supports performance insight, you can quickly assess the load of the target database through simple chart information, identify the root cause of performance problems, and improve the stability of the database.

Prerequisite

Currently, only Alibaba Cloud relational databases RDS and PolarDB are supported.

Background Context

The main sources of data for performance insight are as follows:

  • If the target instance has performance_schema turned on, DAS would directly collect and analyze the data in performance_schema.
  • If performance_schema is not enabled on the target instance, DAS would collect and analyze active session data.

Step-by-step Guideline

  1. Log-on DAS console.

  2. Click Instance Monitoring on the left navigation panel.

  3. On the Instance Monitoring page, find the target instance and click the instance ID.

  4. On the left navigation panel of the instance details page, click Performance Insight .

  5. On the Performance Insight page, click Enable Performance Insight .Turn on

  6. In the dialog box that pops up, click OK .

  7. You can view and manage the following information on the performance insight page.

  • In the Performance Trend area, you can view the database performance in a specific period of time. If you need to view a specific performance (such as CPU usage), you can click the Details button to the right of the performance name to view it.
    Performance trend

    Performance insights data would be available to view up to 7 days.

    • In the Average Session Statistics area, you can view the trend graphs and related multi-dimensional load information lists of different categories (such as SQL) sessions to determine the source of performance problems.active sessions