Tuning

Tag: tuning

Index Usage Stats Insanity - the oddities of sys.dm db index usage stats (Dear SQL DBA)

Index Usage Stats Insanity - the oddities of sys.dm db index usage stats (Dear SQL DBA)

on June 30, 2016

Category: indexing
Tags: dear-sql-dba , dmvs , index-usage-stats , indexes , operational-stats , sys-dm_db_index_operational_stats , sys-dm_db_index_usage_stats , tuning , performance-tuning

SQL Server’s “index usage stats” dynamic management view is incredibly useful– but does it tell you what you THINK it tells you?

I explain the quirks of how sys.dm_db_index_usage_stats works and why the information is so valuable.

Continue reading