Using buffer cache | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Using buffer cache

I ran the PERFMON and noticed that our buffer cache hit ration is running at nearly 100% meaning that all queries are being serviced out of cache rather than from disk. This tells me the SQL Server is loading both our DBs into cache. As we add more databases, the ability for SQL Server to do this will be diminished meaning that both current DBs performance will suffer? CanadaDBA
May yes, may be not. I suppose you have to try and may be add more memory.
Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided “AS IS” with no warranties for accuracy.
To have cache hit ration close to 100% you don’t have to have enough RAM to handle the whole db. It is enough if you can have working set kept there, which means data that are frequently queried. So as Luis said it depends, if total db space is bigger then RAM available you will have to test.
]]>