Advanced Search

Cached Query Plans

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

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. SELECT COUNT(*) AS �NUMBER OF plans�, SUM(CAST(size_in_bytes AS BIGINT))/1024/1024 AS �Plan Cache SIZE (MB)�
  2. FROM sys.dm_exec_cached_plans

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.