SQL Server: Cache Manager

3 4

This object is used to view Cache Manager statistics. Each of the counters can monitor the following instances of the object: Adhoc SQL Plans, Misc. Normalized Trees, Prepared SQL Plans, Procedure Plans, Replication Procedure Plans, and Trigger Plans. The counters are as follows:

• Cache Hit Ratio Ratio between cache hits and misses. This counter is quite useful if you want to determine how effective the SQL Server cache is for your system. If the number that the counter returns is low, you might want to add more memory.
• Cache Object Counts Number of cache objects in the cache.
• Cache Pages Number of 8-kilobyte (KB) pages used by cache objects.
• Cache Use Counts/sec Number of times per second each type of cache object has been used.