Question: I’m experiencing some strange behaviour with response from the SQL Server DMV sys.dm_db_index_usage_stats. I understand the sys.dm_db_index_usage_stats are refreshed every time there is a SQL Server restart. This is documented behaviour , which I build in to my understanding of how to interpret these statistics The strange behaviour is when I execute a ALTER INDEX REBUILD and then check the sys.dm_db_index_usage_stats, the usage stats for the index disappear. I’m using SQL Server 2012 Enterprise SP2 Answer: It sounds like you’re experiencing a bug which appeared in SQL Server 2012 and was fixed in SQL Server 2012 Service Pack 3...
Read more →