bblumentritt

SQLserver probe Buffer Cache Hit Ratio

Discussion created by bblumentritt on Jul 11, 2014
Latest reply on Jul 15, 2014 by BryanMorrow

In the UMP 7 MS SQL Server Unified Dashboard, the Buffer Cache Hit Ratio rating is wrong/backwards.  This metric should always be above 80% and 99% is ideal (and therefore 99% should be Green, not Red).  The data comes from the sqlserver probe (4.84) QOS_SQLSERVER_BUF_CACHEHIT_RATIO, which shows the alarm levels correctly, i.e. <70 Major, <965 Warning.

 

The UMP shows:

Monitors the buffer cache-hit ratio.

0 to 50.99 = Green

51 to 74.99 = Yellow

75 to 84.99 = Orange

85 to 100 = Red

 

It should be:

Monitors the buffer cache-hit ratio.

0 to 50.99 = Red

51 to 74.99 = Orange

75 to 84.99 = Yellow

85 to 100 = Green

 

Is there a way to fix this, or is this a defect in the dashboard?

Outcomes