Monitoring Stored Procedure Performance with sys.dm_exec_cached_plans
February 15, 2008[From SQL Server Performance]
In my last article (http://www.sql-server-performance.com/articles/per/tsql_statement_performance_p1.aspx) I showed how to use the sys.dm_exec_query_stats dynamic management view (DMV). This article showed how to use the information from this DMV to determine what TSQL statements where the worst performing statements on an instance of SQL Server 2005. In this article I will continue on with my performance monitoring discussion and will show how to use the sys.dm_exec_cached_plans DMW to monitor the performance of your stored procedures.
The article continues at http://sql-server-performance.com/articles/per/Monitor_Stored_Procedure_Performance_p1.aspx