Search This Blog

Monday, March 7, 2011

SQL DBA - Use Counts and # of plans for compiled plans

SELECT objtype ,usecounts ,COUNT(*) AS [no_of_plans] FROM sys.dm_exec_cached_plans

WHERE cacheobjtype = 'Compiled Plan' GROUP BY objtype , usecounts

ORDER BY objtype , usecounts ;

No comments: