November 8, 2010 at 3:28 am
I thought that the sys.dm_db_index_usage_stats stats dmv only stored data for indexes that got used 1 or more times. i have been capturing this data for a few days now and am finding many indexes with a sumof zero for seeks, scans, updates.
I thought the indexes might be used in bookmark lookups, but the sum of range_scan_count and singleton_Lookup_count are zero for many of these entries also in the sys.dm_db_index_operational_stats dmf.
am i incorrect in assuming that sys.dm_db_index_usage_stats only collects data on "used" indexes, and it could contain info on indexes that have zero counts for their seeks, scans, updates, etc?
November 8, 2010 at 5:27 am
winston Smith (11/8/2010)
I thought that the sys.dm_db_index_usage_stats stats dmv only stored data for indexes that got used 1 or more times. i have been capturing this data for a few days now and am finding many indexes with a sumof zero for seeks, scans, updates.I thought the indexes might be used in bookmark lookups, but the sum of range_scan_count and singleton_Lookup_count are zero for many of these entries also in the sys.dm_db_index_operational_stats dmf.
am i incorrect in assuming that sys.dm_db_index_usage_stats only collects data on "used" indexes, and it could contain info on indexes that have zero counts for their seeks, scans, updates, etc?
Read the following links.you ll get (sumof zero for seeks, scans, updates.
)
http://technet.microsoft.com/en-us/library/ms188755.aspx
http://msdn.microsoft.com/en-us/library/ms174281.aspx
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply