New DMV for Cached Stored Procedures (SQL 2008 – 2012)
By SQLRx Admin | SQL Administration , Tip of the Month
SQL Server Administration: (SQL 2008 – SQL 2012) Use the new dynamic management view sys.dm_exec_procedure_stats to view performance statistics about cached stored procedures. This dmv will only show information on the stored procedures that are still in the cache. If a stored procedure is aged out or removed from the cache then performance info will […]
Continue reading