We have several databases on an instance of MS SQL Server 2012. Using Glenn Berry's DMV queries, I see the memory buffer pool used by each database.
Is there a way I can limit AltDB to only use a maximum of 10GB. My goal is that more memory is used by MainDB.
DB | Memory Buffer Pool in GB MainDB | 34.00 AltDB | 24.00