Can you configure memory consumption limits in SQL Server per database?

When your SQL Server databases are starting to grow larger, a question about memory consumption and efficient use of resources often rises. For instance, your application's database might grow larger than the physical memory on the server, and thus raising a question about efficiency.

In an SQL Server installation where multiple databases are hosted and one or two of them are larger than the rest, the question often becomes: can I configure per-database memory consumption limits in SQL Server?

Unfortunately, the answer is no. However, you can control memory consumption per SQL Server instance. Thus, if you have a large database and a set of smaller databases, and you want to ensure all get a fair share of memory, you could use two SQL Server instance: one for the large databases (and limit their maximum memory) and another for the small ones (setting both the minimum and maximum memory).

For details on the configuration options, check this article on MSDN.