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!
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!
Updated Mar 14, 2019
Version 2.0
Jose_Manuel_Jurado
Microsoft
Microsoft
