Index Usage Statistics

Supported versions Description Adjustable Settings Schedule
SQL Server 2005, 2008 This procedure visualises the access method frequence (scan method per minute - seeks, scans, lookups and updates) for objects with the highest values of scans.

max objects - The maximum number of objects (indexes, tables) which will be collected into the history table. Only objects with highest values of user_seeks, user_scans and user_lookups are collected.

history threshold - The number of days the statistics (user_seeks, user_scans and user_lookups) will be stored in the history table.

min size - Minimum size (in KB) of an index (or a table - heap) to be checked.

min rows - The minimum number of row an index (or a table - heap) must have to be checked.