In my SQL-Server instance, there are many databases. I want to restrict the memory size of each database (for example 8 GB). When I tried using Resource Governor, there are options like
min_memory_percent and it is given in percentage value (values from 0 to 100). But I want to give the database size explicitly in GB and it should not go beyond that maximum limit.
Is there any way to restrict the database size or to get alerts if the database size exceeds the limit?
Can I implement this using Resource Governor?