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-67428d1ebc5a3419333206/] Aug 14, 2017Anvesh Patel