Page History

The Cache panel tracks the database and procedure processes using a buffer pool of memory on your monitored SQL Server instance. Unexpected spikes in the buffer and procedure cache may alert you to check that you have enough memory for the current pool to function properly. Chronically high cache metrics may indicate the need for server maintenance, query tuning, or index updates to better handle the ongoing workload. For additional information, see Manage your procedure cache.

If the database cache size seems to be too small for optimal performance and there is very little available memory on the system, adding more memory to the system may increase performance. If there is a lot of available memory on the system and the database cache size is not growing beyond a certain point, the database cache size may be capped at an artificially low limit. Increasing this limit may increase performance.

...

The Page Life Expectancy chart provides the time in seconds that a page remains in the cache or buffer pool. The longer your page stays in the cache, the more likely the chance that SQL Server finds that data quickly without a read of physical media and minimize processing resource use. Use the Page Life Expectancy Alertalert to warn you of issues.

Anchor
-153973091 -153973091

Areas chart

...

The Cache Hit Ratios gauge displays the hit rates of the Buffer and Procedure cache in this SQL Server instance. Use the Procedure Cache Hit Ratio Alert(Percent) alert to warn you of issues.

Available alerts

• Page Life Expectancy Alertalert
• Procedure Cache Hit Ratio Alert(Percent) alert