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 Jonathan Kehayias. I read this article on http://www.simple-talk.com. Read the article and challenge your understanding of BCHR once again.
Tagged: Buffer cache hit ratio, SQL Server, SQL server memory
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!
Fill in your details below or click an icon to log in:
You are commenting using your WordPress.com account. ( Log Out / Change )
You are commenting using your Twitter account. ( Log Out / Change )
You are commenting using your Facebook account. ( Log Out / Change )
You are commenting using your Google+ account. ( Log Out / Change )
Connecting to %s
Notify me of new comments via email.
Notify me of new posts via email.
Enter your email address to follow this blog and receive notifications of new posts by email.
Join 56 other followers