http://www.sqlservercentral.com/Content tagged Performance Tuning, DMVs posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)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/