SQL Server : Plan Cache Counters

SQL Server : Plan Cache Counters
These help us monitor the memory usage for storing ad-hoc Transact-SQL statements, stored procedures and triggers etc.

S.NO Performance Counter Name Comments
1 Cache Hit Ratio Ratio between cache hits and lookups. The value of this counter should never fall below 90%.
2 Cache Object Counts Shows the number of objects in cache.
3 Cache Pages Number of 8KB pages in cache.
4 Cache Objects in use Shows the number of objects in cache that are currently being used.

Leave a Reply

Your email address will not be published. Required fields are marked *