Database Autonomy Service (DAS) collects and displays index usage statistics for ApsaraDB RDS for SQL Server instances, covering index fragmentation, access patterns, and storage. Use these statistics to identify indexes that need maintenance or can be safely removed.
Prerequisites
Before you begin, make sure that:
Your RDS instance does not run SQL Server 2008 R2 with cloud disks
Your RDS instance resides 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)
View index usage statistics
Log on to the ApsaraDB RDS console. On the Instances page, select the region where your RDS instance resides, then click the instance ID.
In the left-side navigation pane, choose Autonomy Services > Performance Optimization.
Click the Index Usage tab.
Index Usage tab reference
The Index Usage tab is divided into three sections.
Index overview
The Index Overview section shows a summary of index health for the instance.
| Parameter | Description |
|---|---|
| Total Index Size | Total number of indexes in the instance |
| Total Index Storage | Total storage used by all indexes |
| Fragmentation Percentage Exceeds 30% | Number of indexes with fragmentation above 30% |
| Index Seeks Less Than 100 | Number of indexes with fewer than 100 search operations |
| Data Updated At | Timestamp when the current statistics were collected |
| Recollect | Re-collects index statistics on demand. Click Recollect, then click OK in the confirmation dialog. After a few minutes, refresh the Performance Optimization page to see updated results. |
| Save as PDF File | Saves the current index usage statistics to your computer as a PDF file |