This metric category leverages MSSQL Dynamic Management Views to get recommended indexes.
Default Collection Interval — Every 60 minutes
Table 1-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 |