Function Overview

Description

DBA Assistant provides visualized database O&M and intelligent diagnosis for developers and database administrators (DBAs), making database O&M easy and efficient. By analyzing alarms, resources, health data, performance metrics, and storage usage, it helps users quickly locate faults and keep track of instance status.

Scenarios

Setting a slow session threshold can help you quickly identify abnormal sessions and kill the sessions when an exception occurs in your instance, so that your instance can recover quickly and ensure database availability.
If your DB instance is unstable due to a large number of concurrent SQL requests from new services, you can set concurrency control rules for SQL statements to limit concurrent SQL statements and ensure instance stability.
If your instance storage is full, you can learn about the storage usage and disk space distribution on the Storage Analysis page. Autoscaling is available for you to enable. After this function is enabled, the storage space is automatically scaled up when the storage space is too small.
You can configure auto flow control to limit active connections in high burst traffic or abnormal read/write scenarios to ensure the availability of core workloads.

Supported Regions

You can view the supported regions in Function Overview.

Functions

Table 1 lists the functions supported by DBA Assistant.

**Table 1** Function description
Function	Description	Reference
Dashboard	Shows the status of your instance, including alarms, resource usages, and key performance metrics. DBA Assistant diagnoses instance health using operational data analytics and intelligent algorithms, and provides you with solutions and suggestions for handling detected exceptions.	Viewing the Overall Status of a DB Instance
Sessions	Displays a list of sessions and allows you to filter sessions. You can set a slow session threshold to identify abnormal sessions for urgent instance recovery, ensuring database availability.	Viewing Session Statistics Setting a Slow Session Threshold
Performance	Displays key metrics of your instance and provides metric comparison between different days. You can keep track of metric changes and detect exceptions in a timely manner.	Viewing Performance Metrics
Storage Analysis	Storage occupied by data and logs and historical changes of storage usage are important for database performance. The Storage Analysis page displays storage overview and disk space distribution of your instance. In addition, DBA Assistant can estimate the available days of your storage based on historical data and intelligent algorithms, so that you can scale up storage in a timely manner.	Viewing Storage Usage Viewing Table Diagnosis Results Setting a Diagnosis Threshold Viewing Top Databases and Tables by Physical File Size
Slow Query Log	Displays slow queries within a specified time period. You can view top 5 slow query logs by user or client IP address, sort statistics, and identify sources of slow SQL statements.	Viewing Slow Query Logs
Concurrency Control	Restricts the execution of concurrent SQL statements based on specified rules when there are SQL statements that cannot be optimized timely or a resource (for example, vCPU) bottleneck occurs.	Concurrency Control
Auto Flow Control	Automatically detects database exceptions such as high vCPU usage and excessive active sessions, and limits traffic based on specified priorities. You can control traffic by database or user as required. Limiting traffic of non-core databases or from non-core users can ensure that core workloads remain stable.	Auto Flow Control
Daily Reports	Provides overall information about your instance status of the previous day, including slow SQL analysis and performance & storage analysis. You can download and subscribe to analysis reports. A daily diagnosis is recommended.	Viewing Diagnosis Reports Subscribing to Diagnosis Reports