Return to Snippet

Revision: 25362
at March 29, 2010 02:48 by tvanzele


Updated Code
Select objtype as �Cached Object Type�, count(*) as �Number of plans�, sum(cast(size_in_bytes as bigint))/1024/1024 as �Plan Cache Size (MB)�, avg(usecounts) as �Avg Use Count�
From sys.dm_exec_cached_plans
Group by objtype

Revision: 25361
at March 29, 2010 02:42 by tvanzele


Initial Code
Select objtype as ‘Cached Object Type’, count(*) as ‘Number of plans’, sum(cast(size_in_bytes as bigint))/1024/1024 as ‘Plan Cache Size (MB)’, avg(usecounts) as ‘Avg Use Count’
From sys.dm_exec_cached_plans
Group by objtype

Initial URL

                                

Initial Description

                                

Initial Title
Cached Query Plans per object type

Initial Tags
sql

Initial Language
SQL