Database Autonomy Service (DAS) provides the missing index query feature for ApsaraDB RDS for SQL Server. This feature allows you to view the missing indexes of an ApsaraDB RDS for SQL Server instance.
Usage note
The RDS instance that runs SQL Server 2008 R2 with standard SSDs or enhanced SSDs (ESSDs) is not supported.
Background information
Based on years of service experience, the Alibaba Cloud expert team finds that many customers encounter the following performance issues when they use an ApsaraDB RDS for SQL Server instance: the CPU utilization is high, the IOPS is high, the query statement performance is low, and requests time out. The team finds that more than 90% of the issues are caused by missing indexes.
DAS helps you find the missing indexes of an ApsaraDB RDS for SQL Server instance and export the script files that are required to create the missing indexes. You can create these missing indexes during off-peak hours to solve the performance issues.
Procedure
- Log on to the DAS console.
- In the left-side navigation pane, click Instance Monitoring.
- On the page that appears, find the database instance that you want to manage and click the instance ID. The instance details page appears.
In the left-side navigation pane, choose Performance Optimization > Missing Indexes.
On the Missing Indexes page, view the missing indexes of the ApsaraDB RDS for SQL Server instance.
The Missing Index Overview section provides an overview of the missing indexes of the ApsaraDB RDS for SQL Server instance.
Click Recollect and click OK. The system starts to collect the index usage statistics of the ApsaraDB RDS for SQL Server instance again. After a few minutes, you can refresh the Missing Indexes page to view the updated index usage statistics.
Click Save as PDF File to save the information about the missing indexes to your computer as a PDF file.
The Charts of Missing Index Information section displays the trend of the missing indexes of the ApsaraDB RDS for SQL Server instance.
The Missing Index Details section displays the details about all missing indexes of the ApsaraDB RDS for SQL Server instance.
Click Custom Search, and set filter conditions to query the information about the missing indexes.
Click Export Script, and set filter conditions to export the statements that are used to create the missing indexes.
Click Export File, and set filter conditions to export the missing indexes to an Excel, CVS, or TXT file.