Buffer cache hit ratio – How useful it is?

Memory September 4, 2013 1 Comment

Buffer cache hit ratio(BCHR) : Well every dba who has ever done any Performance tuning work would know about this particular counter. So what is BCHR: Percentage of pages that were found in the buffer pool without having to incur a read from disk.

And how much guidance does it give us….

Well to know that i had to share this great article from . I read this article on http://www.simple-talk.com. Read the article and challenge your understanding of BCHR once again.

Advertisement

Tagged: , ,

One thought on “Buffer cache hit ratio – How useful it is?”

  1. lakeville April 15, 2014 at 11:50 pm Reply

    Good day! This is my first visit to your blog! We are a group of volunteers and starting a new
    project in a community in the same niche. Your
    blog provided us useful information to work on. You have done a extraordinary job!

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

Gravatar
WordPress.com Logo

You are commenting using your WordPress.com account. ( Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. ( Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. ( Log Out /  Change )

Cancel

Connecting to %s

%d bloggers like this: