dcsimg
 

Monitoring Stored Procedure Performance with sys.dm_exec_cached_plans

Friday Feb 15th 2008 by DatabaseJournal.com Staff

This article will show you how to use the sys.dm_exec_cached_plans DMV to monitor the performance of stored procedures.

[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

Mobile Site | Full Site