Category Archives: DMV

When sys.dm_db_index_usage_stats can be misleading

A while ago, I was looking at a particular index which was badly fragmented in development and I decided the best course of action was to rebuild the index. When I then ran my index fragmentation & usage query, the data looked odd. The fragmentation was gone, but the numbers didn’t seem right. It was then I noticed a really low number of index seeks being returned.
Continue reading