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!