When a database instance experiences a performance spike or resource shortage, identifying the cause manually can take hours. Database Autonomy Service (DAS) continuously monitors your database instances and, when it detects an exception, automatically analyzes sessions, SQL statements, and capacity to pinpoint the root cause. DAS then either surfaces an optimization suggestion or — if you have enabled automatic actions — applies the fix and monitors the outcome on your behalf.
Use the autonomy center to review a timeline of all autonomy activity: abnormal events, optimization events, auto scaling events, and other events across a specified time range.
Prerequisites
Before you begin, ensure that your database instance is one of the following types:
ApsaraDB RDS for MySQL
ApsaraDB MyBase for MySQL
ApsaraDB RDS for PostgreSQL
ApsaraDB RDS for SQL Server
PolarDB for MySQL
Tair (Redis OSS-Compatible)
To connect a database instance to DAS, see Connect an Alibaba Cloud database instance to DAS.
How it works
DAS monitors core metrics on each managed database instance. When a metric crosses a threshold that indicates an exception, DAS analyzes sessions, SQL statements, and instance capacity to pinpoint the root cause. Based on that analysis, DAS either surfaces an optimization suggestion or — if you have enabled automatic actions — applies the fix and monitors the outcome.
All autonomy activity is recorded as events in the autonomy center, giving you a single view to track what happened, when, and what DAS did about it.
Features
The autonomy center coordinates the following capabilities:
Anomaly detection — identifies unusual patterns in database metrics before they escalate
SQL throttling — limits high-impact SQL statements to protect overall throughput
Automatic SQL throttling — applies SQL throttling automatically when anomalies are detected
Automatic SQL optimization — rewrites or indexes SQL statements to improve execution plans
Automatic performance scaling — scales instance performance when workload demand exceeds capacity
Automatic space expansion — expands storage automatically when available space runs low
Automatic tablespace fragment recycling — reclaims fragmented tablespace to free usable storage
Abnormal SQL request identification — flags SQL requests that deviate from established baselines
Enable and view autonomy events
Log on to the DAS console.
In the left-side navigation pane, click Instance Monitoring.
Find the database instance you want to manage and click its instance ID. The instance details page appears.
In the left-side navigation pane of the instance details page, click Autonomy Center.
In the upper-right corner of the Autonomy Center tab, click Autonomy Service Settings.
On the Autonomous Function Settings tab of the Autonomous Function Management panel, enable the autonomy service and click OK.
NoteAutomatic actions are applied only when they are expected to improve performance. DAS monitors the outcome after each action and alerts you if the result does not meet expectations, so you can review and take further action if needed.
On the Autonomy Center tab, specify a time range to view events within that period.
The trend chart shows the duration of each event alongside variations in the major metrics of the database instance during that period.
To view more detail about a specific event, find the event in the list and click Details.
FAQ
Why are specific features not displayed on the Autonomous Function Settings tab of the Autonomous Function Management panel?
Each autonomous function supports a specific set of database instance types. If a feature does not appear on the tab, the current instance type is not supported by that feature.