Use Counts and # of plans for compiled plans

-- 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 ;