There seems to be some confusion surrounding Buffer Cache Hit Ratio and the SQL Server Buffer Cache. Having answered several queries concerning this over the last few weeks on a variety of forums I thought I would post here in order set the record straight.
What is the SQL Server Buffer Cache?
The Buffer Cache is an [...]
Posts under ‘Memory’
The SQL Server Buffer Pool and Buffer Cache Hit Ratio
SQL Server Memory Configuration, Determining MemToLeave Settings
Determining the appropriate memory configuration for a SQL Server platform is a task that all database administrators are required to perform. It is essential to ensuring that an appropriate level of performance can be provided.
I am going to discuss some of the additional memory configuration tweaking that you may wish to undertake so that your [...]