Assign maximum memory limit for a particular database in sql server 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 max_memory_percent and 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?

ALTER RESOURCE POOL
There is no way to limit the amount of memory a specific database takes.  SQL Server uses a least used / first evicted from memory policy (basically).