Re: Cache Hit Ratio from system views

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Fri, 17 Aug 2007 03:47:41 GMT
Message-ID: <xT8xi.82911$kK1.41582@newsfe14.phx>

"Bob Jones" <email_at_me.not> wrote in
news:eB8xi.1326$i75.244_at_newssvr19.news.prodigy.net:

>>> Why is BHCR meaningless? The answer should be short and simple. I
>>> want to hear your opinion.
>>
>> One can not prove a negative.
>> Where is your proof BCHR is a reliable indicator of GOOD performance?

>
> BCHR alone does not tell you about overall performance. It simply tell
> you the disk I/O percentage. It is an indicator, a very meaningful
> one.
>

HUH? BCHR does NOT come close to measure disk I/O; so by what stretch of imagination does it measure "I/O percentage"? BCHR measure RAM activity says absoluting NOTHING about disk activity.

You said, "It (BCHR) is an indicator, a very meaningful one."

Please answer each below as a standlone measure of performance

System A has a BCHR of 22. What does it indicate?
System B has a BCHR of 42. What does it indicate?
System C has a BCHR of 62. What does it indicate?
System D has a BCHR of 82. What does it indicate?

Received on Thu Aug 16 2007 - 22:47:41 CDT