Is there a way to configure memory cache or buffers per database?

Sorry, but you can’t allocate SQL Server cache or buffer memory to specific databases. SQL Server is designed to work dynamically, changing its use of resources in order to best optimize the performance of all the databases on your server. If you were to hardcode specific memory amount to one database over another, it would prevent SQL Server from doing what it thinks is best for the current situation, most likely hurting the overall performance of your server.

If you are experiencing performance issues due to lack of enough memory to cache all of the data effectively (in order to achieve a Buffer Hit Cache Ratio of 99% or better), then the easiest and best thing for you to do is add more RAM to your SQL Server. Another option, although more expensive, is to locate each database on its own server.


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 |