In the autonomy center of Database Autonomy Service (DAS), you can query events that occurred within the specified time range. The events include exception events, optimization events, auto scaling events, and other events. DAS monitors the core metrics of a database instance to detect exceptions. If an exception is detected, DAS checks sessions, SQL statements, and the capacity of the database to identify the cause. Then, DAS provides suggestions on how to optimize performance or mitigate losses. You can also authorize DAS to automatically optimize performance or mitigate losses.

Prerequisites

The database instance that you want to manage is of 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
  • ApsaraDB for Redis
Note For information about how to connect a database instance to DAS, see Connect an Alibaba Cloud database instance to DAS.

Overview

  • Exception detection

    DAS detects exceptions 24/7 based on machine learning and fine-grained monitoring data. This detection mechanism allows DAS to detect database exceptions faster than traditional alerting methods that are based on thresholds.

    ItemTraditional solutionDAS
    MethodRule-based or threshold-based AI-based
    Monitored objectsMetrics A wide range of objects, such as metrics, SQL statements, logs, locks, and O&M events
    Low latencyFrom 5 minutes to one or more days Quasi-real-time
    Detection methodFault-driven Exception-driven
    Periodic detectionNot supported Automatic and periodic
    AdaptabilityNot supported Adaptive to services that have different characteristics
    PredictionNot supported Supported
  • Automatic SQL throttling
    Traffic-related exceptions may occur in a database, such as cache penetration, abnormal resource consumption of SQL statements in a released application, or a spike in the traffic from a specific application. In these scenarios, the database can start to terminate sessions. To maintain database stability, you can use database O&M solutions. For example, you can restart the database instance or switch to a secondary instance. However, these solutions may not be effective. The autonomy center of DAS can automatically detect exceptions, identify the SQL statements that need to be throttled, and then perform throttling on the SQL statements.
  • Exception snapshots
    After DAS detects an exception in a database, DAS starts to check the database engine to identify the root cause. If no root cause is found, DAS creates a snapshot of the database for further analysis.
  • SQL optimization

    After you enable the autonomy center service, DAS automatically checks high-risk SQL statements and generates detailed analysis and optimization suggestions.

    • We recommend that you enable the SQL Explorer feature. In this way, DAS can identify and optimize all high-risk SQL statements in your database instead of only slow SQL queries.
    • To generate effective optimization suggestions for SQL statements, DAS samples and analyzes fields in the conditions of related SQL statements within the O&M time window of the database.

Procedure

  1. Log on to the DAS console.
  2. In the left-side navigation pane, click Instance Monitoring.
  3. On the page that appears, 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 Autonomy Center.
  5. On the Autonomy Center page, click Autonomy Service Settings in the upper-right corner.
    Autonomy Service Settings
  6. On the Autonomous Function Settings tab of the Autonomous Function Management panel, turn on the switch and click OK.

FAQ

Why are specific features not displayed on the Autonomy Service Settings tab of the Autonomous Function Management panel? gz01

A: The database instance does not support the features of DAS autonomy center.

References