087. SQL Server Script to check the size of Query Plan Cache

Performance Improvement in SQL, SQL Downloads, SQL SERVER, Sql Server Scripts

As a DBA, when you are dealing with huge SQL OLTP system, you should monitor the size of Query Plan Cache otherwise it affects to your query performance.

1
2
3
4
5
6
select
    name
    ,sum(pages_kb) /1024.0 InMBUsed
from sys.dm_os_memory_clerks
where name = 'SQL PLans'
group by name