This article is half-done without your Comment! *** Please share your thoughts via Comment ***
In this post, I am sharing a script to check the size of Query Plan Cache in SQL Server.
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 |
Leave a Reply