Advanced Search

Cached Query Plans per object type

/ Published in: SQL
Save to your folder(s)

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  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


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.