|
-
Re: Re: Re: Re: Re: Buffer cache hit ratio.....
Originally posted by abhaysk
So, why bother on HIT Ratio and just start looking for BAD SQLs and every one will be happy !
Ah, but WHEN do you look for BAD SQL? Possible answers:
a) when someone complains
b) when the hit ratio changes unexpectedly
To my mind it's like a doctor using a thermometer: if the patient's temperature is normal, it doesn't necessarily mean he/she is in good health; if it is abnormal, better find out why.
On p11 of Millsap's article, he describes the hit ratio as "unreliable" - by his definition the doctor's thermometer is "unreliable" too. Would you expect doctors to stop using thermometers?
What would you think of a doctor who:
a) never used a thermometer?
b) never used anything but a thermometer?
Last edited by DaPi; 01-29-2004 at 05:45 AM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote