SQL Server: Script to check the size of Query Plan Cache

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. [crayon-663a583b655bc382986632/] Aug 14, 2017Anvesh Patel