Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
monty
Posting Yak Master
130 Posts |
 Posted - 2006-12-03 : 06:07:07
|
| Hi All,please through your expertise on this counter, iam aware of the fact that this counter reffers to how often SQL Server goes to the buffer, not the hard disk, to get data. and should be around 90-95%.my question this counter is ratio between Buffer cache hits and what, is it disk? and if any one can expalin with an example it wld be gr8..its me monty |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-12-03 : 08:24:25
|
| My understanding is that the ratio is the %age of the time that the requirement can be satisfied from data which is buffered in cache [presumably in memory], without having to resort to accessing the physical database [on the disk].Kristen |
 |
|
|
|
|
|
Buffer Cache Hit Ratio.