During daily O&M of ApsaraDB RDS for SQL Server instances, you can use Database Autonomy Service (DAS) to handle instance failures, optimize instance performance, improve efficiency, and reduce O&M costs. DAS is a cloud service that is developed based on machine learning and expert experience. DAS provides self-awareness, self-healing, self-optimization, self-O&M, and self-securing capabilities to simplify database O&M tasks and ensure the stability, security, and efficiency of database services.
Limits
DAS is supported only in the following regions: China (Hangzhou), China (Shanghai), China (Qingdao), China (Beijing), China (Zhangjiakou), China (Hohhot), China (Ulanqab), China (Shenzhen), China (Heyuan), China (Chengdu), China (Hong Kong), and Singapore.
Feature description
Autonomy services that are provided by DAS for ApsaraDB RDS for SQL Server provide the following features:
This feature allows you to monitor and analyze your storage at the instance level, database level, and table level. The storage monitoring and analysis data help you identify and troubleshoot storage issues. The Storage Management page in the ApsaraDB RDS console includes the following sections:
Storage Overview: This section provides an overview of the storage information. The storage information includes the changes in storage over the last week, the available storage, the used storage, and the estimated increase in storage consumption.
Charts of Storage Information: This section displays the storage consumption of your RDS instance in charts. The storage consumption includes the storage usage, the percentages of used data storage and used log storage, and the top 5 databases that consume the most storage.
Storage Trend: This section displays the storage trends of your RDS instance in a chart.
Top 10 Databases: This section displays the details of the top 10 databases that consume the most storage. These details are displayed in a table.
Top 20 Data Tables: This section displays the details of the top 20 data tables that consume the most storage. These details are displayed in a table.
Performance Optimization
This feature provides various important performance data about your RDS instance. The Performance Optimization page in the ApsaraDB RDS console includes the following tabs:
Performance Insight: This tab displays the performance metrics of your RDS instance. You can use the metrics to find the sources of performance issues and improve the stability of your RDS instance. For more information, see Use the performance insight feature for an ApsaraDB RDS for SQL Server instance.
Missing Indexes: This tab displays details about the missing indexes in charts and tables. This tab also provides the SQL statements that are used to create these indexes. For more information, see View the missing indexes of an ApsaraDB RDS for SQL Server instance.
Index Usage: This tab displays details about the created indexes in charts and tables. This tab also provides the SQL statements that are used to create these indexes. For more information, see View the index usage statistics of an ApsaraDB RDS for SQL Server instance.
Statistics: This tab displays the performance statistics of your RDS instance in charts and tables. For more information, see View the performance statistics of an ApsaraDB RDS for SQL Server instance.
TOP SQL: This tab displays the SQL statements that are executed on your RDS instance. These SQL statements are sorted from various dimensions and are displayed in charts and tables. You can query real-time Top N SQL statements. For more information, see View the SQL statement statistics of an ApsaraDB RDS for SQL Server instance.
TOP Objects: This tab displays the real-time performance drains that are caused by various objects, such as stored procedures, functions, and triggers. You can identify the top N objects that cause the highest performance drain and the SQL statements in these objects. For more information, see View the top N objects of an ApsaraDB RDS for SQL Server instance.
Lock Optimization
This feature provides various important performance data about your RDS instance. The Lock Optimization page in the ApsaraDB RDS console includes the following tabs:
DeadLock: This tab displays the details of the deadlocks that are detected in your RDS instance. The details are displayed in charts and tables. For more information, see View the deadlock statistics of an ApsaraDB RDS for SQL Server instance.
Blocking: This tab displays the details of the blocking problems that are detected in your RDS instance. The details are displayed in charts and tables. For more information, see View the blocking statistics of an ApsaraDB RDS for SQL Server instance.
Slow Query Logs: This feature records and analyzes the SQL statements with high CPU utilization. This feature also displays the slow SQL query statistics and the slow SQL query details. For more information, see Analyze the slow SQL statements on an ApsaraDB RDS for SQL Server instance.
Dashboard: This feature allows you to select the RDS instances and metrics that you want to monitor. This way, you can monitor and compare the metrics of different RDS instances and use multiple metrics at a time to monitor the status of the RDS instances. For more information, see Use the monitoring dashboard feature.
SQL Explorer and Audit: This feature is developed based on the full request feature and the SQL Audit feature. In addition, this feature is integrated with the features such as Search and SQL Explorer. This feature helps you obtain information about the SQL statements that are executed. You can use the information to troubleshoot various performance issues. For more information, see Use the SQL Explorer and Audit feature on an ApsaraDB RDS for SQL Server instance.