• Management Pack:  SQL Server 2008
  • MP Version:  7.0.4.0
  • Released:  4/18/2018
  • Publisher:  Microsoft

Buffer Cache Hit Ratio Monitor

  • ID:  Microsoft.SQLServer.2008.DBEngine.BufferCacheHitRatioMonitor
  • Description:  Buffer Cache Hit Ratio for 2008 DB Engine
  • Target:  SQL Server 2008 DB Engine
  • Enabled:  Yes

Operational States

Name State Description
DB Engine Buffer Cache Hit Ratio is ok Success DB Engine Buffer Cache Hit Ratio is ok
DB Engine Buffer Cache Hit Ratio is too low Error DB Engine Buffer Cache Hit Ratio is too low

Overridable Parameters

Parameter Name Default Value Description Override
Interval (seconds) 300 The recurring interval of time in seconds in which to run the workflow.
Threshold 0 Threshold
Number of samples 6 Indicates how many times a measured value should breach a threshold before the state is changed.

Alert Details

Monitor State Message Priority Severity Auto Resolution
DB Engine Buffer Cache Hit Ratio is too low (Error) Buffer Cache Hit Ratio is too low Medium Critical Yes

Run As Profiles

Name
Default

Monitor Knowledgebase

Summary

Buffer Cache Hit Ratio monitor for SQL 2008 DB Engine

Percentage of pages that were found in the buffer pool without having to incur a read from disk.

Causes

Zero value indicates memory bottleneck - SQL Server cannot efficiently cache the data pages in memory; reads from disk are relatively high.

Resolutions
  • Increase available memory on the server.

  • Set SQL Max memory to higher limit.

  • Provide index optimization.

External References
This monitor does not contain any external references.

See Also for SQL Server 2008 Management Pack


Downloads for SQL Server 2008 Management Pack

AZURE OPTIMIZATION ASSESSMENT GET STARTED
MIGRATION TO AZURE GET STARTED
SYSTEM CENTER MIGRATION TO AZURE GET STARTED
MIGRATION TO AZURE FOR SQL AND WINDOWS 2008 GET STARTED