Instance profile
Database Autonomy Service (DAS) provides the Instance Portrait feature. This feature uses AI and big data analytics to create a personalized profile for your database instance based on its operational characteristics. Instance Portrait provides a comprehensive overview of your database instance, helps you identify anomalies and defects, and recommends autonomous features based on the profile.
Prerequisites
The database instance is connected to DAS, and its accessed state is Normal. For more information, see Connect an Alibaba Cloud database instance to DAS.
The instance profile feature does not support RDS MySQL Basic Edition instances.
Database Autonomy Service (DAS) began a gradual rollout of the instance profile feature on December 5, 2022.
Features
Instance Portrait diagnoses your database instance across six dimensions: resource, session, access, request, risk, and load. It provides a composite score and guided recommendations based on which autonomous features are enabled.
-
resource: Primarily analyzes disk, memory, and space usage.
-
session: Primarily analyzes active and abnormal sessions on the database instance.
-
access: Primarily analyzes new and unknown sources of access to the database instance.
-
request: Primarily analyzes slow SQL requests, provides optimization suggestions, and estimates potential optimization benefits.
-
risk: Primarily analyzes risks such as high-risk SQL operations and SQL injection.
-
load: Primarily analyzes the load level and operational performance of the database instance.
Procedure
Log on to the DAS console.
In the navigation pane on the left, click .
Find the target instance and click the instance ID to open the instance details page.
-
In the navigation pane on the left, click Instance Portrait.
-
On the Instance Portrait page, select a time range. Review the diagnostic results to identify any anomalies or defects, and decide whether to take action.
A radar chart on the left displays the score for each dimension, while tabs on the right display detailed diagnostic information.
-
In the Diagnostic Chart area, you can hover over a point on a dimension to view its related metrics.
-
In the Diagnostic Result area, view the diagnostic results for each dimension.
-
If a relevant autonomous feature is enabled for the database instance, the system displays its operational status.
-
If a relevant autonomous feature is not enabled, the system recommends enabling it.
Click the recommendation to go to the feature's page and complete the configuration as suggested.
-
Click Handle Now to open the Risk Handling dialog box. If anomalies or defects are found, the system recommends which autonomous features to use. Click Handle Now to go to the relevant autonomous feature page and configure the feature as suggested. The Current Diagnostic Result area in the Risk Handling dialog box displays diagnostic scores and suggestions for the six dimensions: resource, session, access, request, risk, and load. For example, if the session score is 5, DAS recommends enabling Automatic SQL Throttling. If the load score is 50, it recommends enabling Autonomous Auto Scaling. To take action on a dimension, click Handle Now to its right.
-
-