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

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.


Leave a comment

Your email address will not be published.