A bLoG by ♚ Suresh babu ♚
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 ;
Post a Comment
No comments:
Post a Comment