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