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