http://www.sqlservercentral.com/Articles tagged DMVs posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)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? http://www.sqlservercentral.com/redirect/articles/63897/2008/08/05http://www.sqlservercentral.com/redirect/articles/63897/This article will show you how to use the sys.dm_exec_cached_plans DMV to monitor the performance of stored procedureshttp://www.sqlservercentral.com/redirect/articles/62305/2008/03/13http://www.sqlservercentral.com/redirect/articles/62305/Many application performance problems can be traced to poorly performing database queries; however, there are many ways you can improve database performance. SQL ServerTM 2005 gathers a lot of information that you can use to identify the causes of such performance issues.http://www.sqlservercentral.com/redirect/articles/61836/2008/01/11http://www.sqlservercentral.com/redirect/articles/61836/Every developer needs to ensure that each TSQL statement is optimized. This article will give you a few different ideas on how to identify slow running queries and provide you with some tips on monitor your query performance while you make iterative changes to each query to try and improve performance.http://www.sqlservercentral.com/redirect/articles/61834/2008/01/08http://www.sqlservercentral.com/redirect/articles/61834/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_statshttp://www.sqlservercentral.com/redirect/articles/61421/2007/11/12http://www.sqlservercentral.com/redirect/articles/61421/