Lesson Learned #48: Does Azure SQL Database Managed Instance support Resource Governor?

Published 03-13-2019 07:02 PM 1,417 Views
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!
%3CLINGO-SUB%20id%3D%22lingo-sub-369052%22%20slang%3D%22en-US%22%3ELesson%20Learned%20%2348%3A%20Does%20Azure%20SQL%20Database%20Managed%20Instance%20support%20Resource%20Governor%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-369052%22%20slang%3D%22en-US%22%3E%0A%20%26lt%3Bmeta%20http-equiv%3D%22Content-Type%22%20content%3D%22text%2Fhtml%3B%20charset%3DUTF-8%22%20%2F%26gt%3B%3CSTRONG%3EFirst%20published%20on%20MSDN%20on%20May%2010%2C%202018%20%3C%2FSTRONG%3E%20%3CBR%20%2F%3E%20The%20answer%20is%20Yes!%20and%20it%20is%20great%20to%20know.%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20Currently%2C%20using%20Azure%20SQL%20Database%20Managed%20Instance%20we%20could%20configure%20a%20subset%20of%20the%20physical%20resources%20of%20an%20instance%20of%20the%20Database%20Engine.%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Frelational-databases%2Fresource-governor%2Fresource-governor-resource-pool%3Fview%3Dsql-server-2017%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3ESQL%20Server%20Resource%20Governor%20%3C%2FA%3E%20%2C%26nbsp%3Benables%20us%20to%20specify%20limits%20on%20the%20amount%20of%20CPU%2C%20physical%20IO%2C%20and%20memory%20that%20incoming%20application%20requests%20can%20use%20within%20the%20resource%20pool.%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20If%20you%20need%20that%20any%20specific%20user%20or%20application%20has%20any%20specific%20limitation%20in%20terms%20of%20CPU%20and%20RAM%2C%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Frelational-databases%2Fresource-governor%2Fresource-governor-resource-pool%3Fview%3Dsql-server-2017%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%20Server%20Resource%20Governor%20%3C%2FA%3E%20is%20your%20option.%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20Unfortunately%2C%20in%20Azure%20SQL%20Database%20is%20still%20not%20supported.%20In%20similar%20way%2C%20if%20you%20use%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fsql-database%2Fsql-database-elastic-pool%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%20Elastic%20Database%20Pool%20%3C%2FA%3E%20we%20could%20configure%20the%20maximum%20eDTU%20per%20database%2C%20but%2C%20for%20all%20database%20not%20per%20each.%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20Enjoy!%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-369052%22%20slang%3D%22en-US%22%3EFirst%20published%20on%20MSDN%20on%20May%2010%2C%202018%20The%20answer%20is%20Yes!%20and%20it%20is%20great%20to%20know.%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-369052%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Eazure%20sql%20managed%20instance%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Eresource%20governor%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Version history
Last update:
‎Mar 13 2019 07:02 PM
Updated by: