Missing Indexes
This metric category leverages MSSQL Dynamic Management Views to get recommended indexes.
Default Collection Interval — Every 60 minutes
Table 2-54 Missing Indexes Metrics
| Metric | Description |
|---|---|
|
Database Name |
Name of the database. |
|
Database ID |
Database identifier. |
|
Fully Qualified Table Name |
Available space for data file |
|
Table ID |
Table identifier. |
|
Equality Columns |
Columns that are queried when this index would be used. |
|
Inequality Columns |
Columns that are queried when this index would be used. |
|
Included Columns |
Columns often included in the result set when this index would be used. |
|
Unique Compiles |
Number of unique compiles. |
|
Last User Seek Time |
Time of the last user seek. |
|
Last User Scan Time |
Time of the last user scan. |
|
Last System Seek Time |
Time of the last system seek. |
|
Last System Scan Time |
Time of the last system scan. |
|
Estimated Performance Benefit |
Unitless measure of estimated benefit from this index. Useful only to compare to other recommended indexes. |
|
Generated Index Name |
Name generated based on table name and columns involved and included. |
|
User Seeks per second |
User Seeks per second |
|
User Scans per second |
User Scans per second |
|
System Seeks per second |
System Seeks per second |
|
System Scans per second |
System Scans per second |