Database Autonomy Service (DAS) provides the performance insight feature. This feature provides charts and tables to help you evaluate database workloads and identify the causes of database performance issues. This helps improve the stability of your databases.

Prerequisites

DAS supports the following types of database instances:
  • RDS MySQL
  • RDS PostgreSQL
  • PolarDB MySQL
  • PolarDB PostgreSQL
  • PolarDB O

Background information

The performance insight feature collects and analyzes data from the following major 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. Find the database instance that you want to manage and click the instance ID. The instance details page appears.
  4. In the left-side navigation pane, click Performance Insight. On the Performance Insight page, you can manage your database instance and view the following information:
    • In the Performance Insight section, you can specify a time range to view the database performance metrics within the specified period. You can view the details of a specific performance metric. For example, if you want to view the CPU utilization of the instance, click Details next to Memory Usage/CPU Utilization.
      Note The details of a performance metric provide insights into the data generated within the last seven days.
    • In the Average Active Session section, you can view the trend charts of different types of sessions, including SQL statements. You can also view the database workloads from multiple dimensions. This helps you identify the root causes of performance issues.