February 18, 2010 at 5:46 am
How system_seeks, system_scans and system_lookups are different in sys.dm_db_index_usage_stats? This will inform me which index is least used and I shall think about removing that.
-Lk
February 18, 2010 at 5:54 am
What do you mean? How are they different from what?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 18, 2010 at 7:21 am
luckysql.kinda (2/18/2010)
How system_seeks, system_scans and system_lookups are different in sys.dm_db_index_usage_stats? This will inform me which index is least used and I shall think about removing that.-Lk
Shouldn't you be looking at user seeks, scans, and lookups too?
It's all detailed in Books Online: (hit F1!)
About the only thing that isn't clear from the documentation is that all KEY lookups are counted against the clustered index.
Paul
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply