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.|