First published on MSDN on May 10, 2018
The answer is Yes! and it is great to know.
Currently, using Azure SQL Database Managed Instance we could configure a subset of the physical resources of an instance of the Database Engine.
SQL Server Resource Governor
, enables us to specify limits on the amount of CPU, physical IO, and memory that incoming application requests can use within the resource pool.
If you need that any specific user or application has any specific limitation in terms of CPU and RAM,
Server Resource Governor
is your option.
Unfortunately, in Azure SQL Database is still not supported. In similar way, if you use
Elastic Database Pool
we could configure the maximum eDTU per database, but, for all database not per each.
Enjoy!
