Is it normal for the buffer cache size to vary throughout the day?

Question

When I monitor my SQL Server, I can see that the buffer cache size (number of pages) grows through out the day as the number of user connections increase. This cache size varies between 2-3MB to 30-35MB. The server has 256MB and is dedicated to running SQL Server. The buffer cache hit ratio is 99.5%, so I am assuming everything is running OK.

Answer

The behavior you are seeing is normal. As more users access SQL Server, SQL Server will increase the buffer cache as necessary to ensure a high hit ratio (assuming there is RAM to do so).

If your buffer cache ratio is over 90%–as it is in your case–can you can be sure that SQL Server has all the RAM it needs to run as efficiently as it can.




Array

No comments yet... Be the first to leave a reply!

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |