The Cache window shows information
related to the Buffer cache and the Procedure cache.
It is splitted in two parts:
1. General cache statistics
Cache hit ratios
Buffer cache Percentage of pages found in the buffer 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 an instance of SQL Server was started. After a long period of time, the ratio moves very little. Because reading from the cache is much less expensive than reading from disk, you want this ratio to be high. Generally, you can increase the buffer cache hit ratio by increasing the amount of memory available to SQL Server. Procedure cache Ratio between cache hits and lookups.
Total Total amount of dynamic memory (in kilobytes) that the server is using currently. Connection Total amount of dynamic memory the server is using for maintaining connections. Sort, Hash, Index Total amount of memory currently granted to executing processes such as hash, sort, bulk copy, and index creation operations. Optimizer Total amount of dynamic memory the server is using for query optimization. Lock Total amount of dynamic memory the server is using for locks. Free Total number of free memory.
2. Procedure cache detailed statistics
The Cache manager grid shows each individual cache type with the followings counters:
Hit ratio Ratio between cache hits and lookups. Object Counts Number of cache objects in the cache. Pages Number of 8-kilobyte (KB) pages used by cache objects. Use Counts per second Times each type of cache object has been used.
By default, the last snapshot is displayed in the grid. Use the slidder (or the arrow buttons) located at the top of the grid to navigate through the collected snapshots. In monitoring, the "Auto Update" button must be unchecked to be able to navigate through the collected snapshots.
Select one or more cache types in the grid (Check box at the left of the grid) to update the graphes located at the bottom of the window. If several entries are selected, the statistics are aggregated.
Copyright © AgileLoad. All rights reserved.