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.
