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

Content with tags SQL Server 2005, DMV Rss

   Items 1 to 2 of 2   

SQL Server System Configuration Values

Often times we need to review the SQL Server instance configuration values while troubleshooting performance problems. What alternatives are available to capture this information? With all of the new views in SQL Server 2005, is one available with the configuration values, a description and the list of possible values?   Read more...
By Additional Articles 2008/08/05 | Source: MSSQLTips.com | Category: dmv
Rating: (not yet rated)  Rate this |   Briefcase | 3,861 reads

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,839 reads
   Items 1 to 2 of 2   
administration (1)    
indexing (1)