Database Autonomy Service (DAS) allows you to view the index usage statistics of an ApsaraDB RDS for SQL Server instance. The statistics include the usage of indexes and the degrees of fragmentation in indexes.
Usage note
The RDS instance that runs SQL Server 2008 R2 with standard SSDs or enhanced SSDs (ESSDs) is not supported.
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 > Index Usage.
On the Index Usage page, view the index usage statistics of the ApsaraDB RDS for SQL Server instance.
The Index Overview section provides an overview of the index usage statistics of the ApsaraDB RDS for SQL Server instance.
Click Recollect and click OK. ApsaraDB RDS starts to collect the index usage statistics of the ApsaraDB RDS for SQL Server instance again. After a few minutes, you can refresh the Index Usage page to view the updated index usage statistics.
Click Save as PDF File to save the index usage statistics of the ApsaraDB RDS for SQL Server instance to your computer as a PDF file.
The Charts of Index Information section displays the trend of the index-related metrics.
The Index Information Table section displays the details about the usage of all indexes in the ApsaraDB RDS for SQL Server instance.
Click Custom Search, and set filter conditions to query the information about the specified indexes.
Click Export Script, and set filter conditions to export the statements that are used to create the specified indexes.
Click Export File, and set filter conditions to export the specified indexes to an Excel, CVS, or TXT file.