Collecting Index Usage Statistics
Knowing when and how often your indexes are used can really come in handy. Indexes that are never utilized aren't worth keeping around, and knowing their usage patterns can be a big help when making decisions regarding things such as filegroup placement and compression settings. SQL Server 2005 brought some great advancements in the form of the sys.dm_db_index_usage_stats DMV, which returns statistics on index usage that are automatically being kept by the server. While it's a step forward, I feel it still leaves a few things to be desired: The values are cumulative since the server was last restarted Once…