SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tags SQL Server 2005, DMV, Administration Rss

   Items 1 to 1 of 1   

Index related DMVs and DMFs - sys.dm_db_index_usage_stats

Examining statistics of indexes is useful for optimizing the performance of queries. Statistics help us determine the usage and worth of indexes - one simple method is using the index-related dynamic management view; sys.dm_db_index_usage_stats  Read more...
By Additional Articles 2007/11/12 | Source: SQL Server Performance | Category: sql server 2005
Rating: (not yet rated)  Rate this |   Briefcase | 2,850 reads
   Items 1 to 1 of 1