Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Content with tags Administration, DMV, SQL Server 2005 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,617 reads
   Items 1 to 1 of 1