Autonomy Services provides the in-depth test feature to check for anomalies in key instance metrics. Use the test results to promptly address any exceptions.
What it does
The in-depth test feature checks the following database instance metrics for abnormalities:
Database storage usage
Number of blocking and deadlock events
Slow SQL queries
Average active sessions
Database log growth
Prerequisites
-
This feature is not available for ApsaraDB RDS for SQL Server 2008 R2 instances that use cloud disks.
-
Your ApsaraDB RDS instance must be in one of the following regions: China (Hangzhou), China (Shanghai), China (Qingdao), China (Beijing), China (Zhangjiakou), China (Hohhot), China (Ulanqab), China (Shenzhen), China (Heyuan), China (Guangzhou), China (Chengdu), China (Hong Kong), Singapore, or UAE (Dubai).
Procedure
-
Go to RDS Instances, select a region at the top, and then click the ID of the target instance.
-
In the left-side navigation pane, choose Autonomy Services > Performance Optimization.
-
On the In-depth Test tab, view the test results for key instance metrics.
-
Click Recollect. The system recollects data asynchronously. Refresh the page after a few minutes to view the latest data.
-
Click Save as PDF to save the page's data to your local computer.
The results table includes columns such as Rule Name, Rule Description, Rule Level, Detected Object, Unit, Result Description, and Last Updated. For example, the SingleUseRatio rule checks the percentage of single-use execution plans in the execution plan cache of the database. A High Risk level indicates that more than 50% of statements are executed only once. In this case, we recommend that you parameterize the statements.
-