Cache Manager

The Cache Manager object provides counters to monitor how Microsoft SQL Server uses memory to store objects such as stored procedures, ad hoc and prepared Transact-SQL statements, and triggers. Multiple instances of the Cache Manager object can be monitored at the same time, with each instance representing a different type of plan to monitor.

For Microsoft SQL Server 2008/2012/2014/2016

Default Collection Interval — Every 15 minutes

Table 2-8 Cache Manager Metrics

Metric	Description
Cache Manager Counter Name (key column)	Performance metric name.
Cache Manager Instance Name (key column)	Instance for the Cache Manager counter name.

The Cache Manager Counter Name key column contains several metrics. The following table provides a list of these metrics and a description for each.

Table 2-9 Cache Manager Counter Name Metrics

Metric	Description
Cache Hit Ratio	Percentage of pages found in the cache without having to read from disk. The ratio is the total number of cache hits divided by the total number of cache lookups since Microsoft SQL Server was started. After a long period of time, the ratio does not change very much. Because reading from the cache is less expensive than reading from disk, this ratio should be high. Generally, you can increase the cache hit ratio by increasing the amount of memory available to Microsoft SQL Server.
Cache Hit Ratio Base	Denominator ("base") of a fraction that the performance counter Cache Hit Ratio represents.
Cache Pages	Number of pages used by objects in the cache. After a long period of time, the count does not change very much.
Cache Object Counts	Number of objects found in the cache. After a long period of time, the count does not change very much.
Cache Use Counts/sec	Number of times per second that each type of object in the cache has been used. The higher this value is, the better. After a long period of time, the count does not change very much.