EX0011 : Identify inefficient indexes using dynamic management views information |
 |
The topic describes the EX0011 analysis rule.
MessageIdentify inefficient indexes using dynamic management views information
DescriptionThe rule checks for indexes that haven’t been used recently and are possible candidates to be dropped.
The rule uses the SQL Server Dynamic Management Views to get index usage information.
The unused indexes information is based on statistics gathered since the last time SQL Server instance was started.
 Note |
|---|
|
Be careful when dropping unused or rarely used indexes. Some indexes can be used rarely and be created for specific purpose; for example, to optimize monthly report. |
How to fixScopeThe rule has a ContextOnly scope and is applied only on current server and database schema.
Parameters| Name | Description | Default Value |
|---|---|---|
| IndexEfficiencyMininumPercent |
The parameter specifies the efficiency of the index since the last server restart. The index efficiency is calculated based on the reads per writes. |
100 |
| IndexMinimumNumberOfRows |
Indexes covering less rows than specified by this parameter will be ignored. |
10000 |
RemarksThe rule requires SQL Connection. If there is no connection provided, the rule will be skipped during analysis.
Effort To FixCategoriesExplicit Rules, Performance Rules, Maintenance Rules, Bugs
Additional InformationThere is no additional info for this rule.
See Also