Function Overview

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, and performance metrics, it helps users quickly locate faults and keep track of instance status.

To use DBA Assistant on the RDS console, IAM users must have the RDS FullAccess, DAS FullAccess, DAS Administrator, and CES FullAccess permissions. For details, see Creating a User and Granting Permissions.

Scenarios

In emergency cases, you can manually terminate slow sessions to recover your instance, improving 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. You can enable storage autoscaling. When the available storage of your instance drops to the threshold, autoscaling is triggered. For details, see Storage Autoscaling.

Supported Regions

DBA Assistant is available in the following regions: CN North-Beijing4, CN East-Shanghai1, CN East2, CN South-Guangzhou, AF-Johannesburg, CN Southwest-Guiyang1, CN-Hong Kong, AP-Bangkok, AP-Singapore, ME-Riyadh, TR-Istanbul, and LA-Sao Paulo1.

To use DBA Assistant in any other regions, contact customer service to apply for required permissions.

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	The Sessions page displays slow sessions, active sessions, and total sessions. You can quickly filter slow sessions or active sessions by user, host IP address, or database name. Kill Session and Concurrency Control can be used for urgent instance recovery to ensure database availability.	Managing Real-Time Sessions
Performance	The Performance page 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. Monitoring by Seconds helps accurately locate faults.	Viewing Performance Metrics of a DB Instance
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 of a DB Instance
SQL Insights	After Collect All SQL Statements is enabled, you can gain a comprehensive insight into SQL statements on the SQL Explorer page. Top SQL helps you locate exceptions.	Creating a SQL Insights Task
Concurrency Control	Concurrency Control restricts the execution of SQL statements based on specified rules when there are SQL statements that cannot be optimized timely or a resource (for example, vCPU) bottleneck occurs.	Creating a Concurrency Control Rule