Posted By

tvanzele on 03/29/10


Tagged

sql DMV


Versions (?)

Who likes this?

1 person have marked this snippet as a favorite

Tyster


Cached Query Plans per object type


 / Published in: SQL
 

  1. 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�
  2. FROM sys.dm_exec_cached_plans
  3. GROUP BY objtype

Report this snippet  

You need to login to post a comment.