Monitoring Stored Procedure Performance with sys.dm_exec_cached_plans

Friday Feb 15th 2008 by DatabaseJournal.com Staff
Share:

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

Share:
Home
Mobile Site | Full Site
Copyright 2017 © QuinStreet Inc. All Rights Reserved