Resource Governor -- can it be part of the standard release?

%3CLINGO-SUB%20id%3D%22lingo-sub-2661182%22%20slang%3D%22en-US%22%3EResource%20Governor%20--%20can%20it%20be%20part%20of%20the%20standard%20release%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2661182%22%20slang%3D%22en-US%22%3E%3CP%3EFolks%2C%20especially%20Microsoft%20people%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20Resource%20Governor%20be%20made%20part%20of%20the%20standard%20release%20(i.e.%20not%20requiring%20the%20Enterprise%20license)%3F%3C%2FP%3E%3CP%3EAt%20work%2C%20I%20saw%20a%20customer%20problem%20that%20could%20be%20resolved%20if%20we%20could%20use%20this%2C%20but%20most%20of%20our%20installations%20only%20use%20the%20standard%20release%20(apparently%2C%20it's%20MUCH%20more%20cost%20effective%2C%20especially%20for%20multiple%20independent%20installations%2C%20or%20where%20the%20customer%20has%20to%20pay).%26nbsp%3B%20Also%2C%20it%20seems%20to%20me%20that%20it%20would%20make%20SQL%20Server%20much%20more%20%22sticky%22%20--%20i.e.%20much%20more%20useful%2C%20and%20therefore%20something%20developers%20would%20stick%20with%20and%20rely%20on.%26nbsp%3B%20The%20problem%20is%20treating%20interactive%20queries%20(Which%20should%20be%20fast)%20from%20%22server%22%20or%20computation%20queries%20(which%20can%20be%20slow%2C%20and%20take%20a%20while%20anyway).%26nbsp%3B%20Seems%20that%20even%20small%20installations%20or%20applications%20might%20benefit%20from%20being%20able%20to%20prioritize%20the%20various%20types%20of%20connections%2C%20i.e.%20what%20the%20database%20is%20being%20used%20for%20in%20each%20case.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you're%20a%20user%20and%20agree%2C%20please%20post.%26nbsp%3B%20If%20you're%20someone%20from%20microsoft%20and%20agree%2C%20please%20post%20as%20well!%26nbsp%3B%20It%20would%20be%20good%20to%20get%20a%20bunch%20of%20people%20pushing%20for%20this.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESteve%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2663555%22%20slang%3D%22en-US%22%3ERe%3A%20Resource%20Governor%20--%20can%20it%20be%20part%20of%20the%20standard%20release%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2663555%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1131476%22%20target%3D%22_blank%22%3E%40StevenHanderson%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESee%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Fsql-server%2Feditions-and-components-of-sql-server-version-15%3Fview%3Dsql-server-ver15%23RDBMSSP%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EEditions%20and%20supported%20features%20of%20SQL%20Server%202019%20(15.x)%3C%2FA%3E%20%3D%26gt%3B%26nbsp%3BRDBMS%20scalability%20and%20performance%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E(I%2FO)%20Resource%20Governor%20is%20only%20available%20in%20Enterprise%20Edition.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOlaf%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2665092%22%20slang%3D%22en-US%22%3ERe%3A%20Resource%20Governor%20--%20can%20it%20be%20part%20of%20the%20standard%20release%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2665092%22%20slang%3D%22en-US%22%3EWhat%20I'm%20advocating%20is%20that%20Microsoft%20change%20its%20releases%20(i.e.%20change%20its%20mind)%20so%20that%20it%20is%20included%20in%20the%20Standard%20licensed%20version.%3C%2FLINGO-BODY%3E
New Contributor

Folks, especially Microsoft people:

 

Can Resource Governor be made part of the standard release (i.e. not requiring the Enterprise license)?

At work, I saw a customer problem that could be resolved if we could use this, but most of our installations only use the standard release (apparently, it's MUCH more cost effective, especially for multiple independent installations, or where the customer has to pay).  Also, it seems to me that it would make SQL Server much more "sticky" -- i.e. much more useful, and therefore something developers would stick with and rely on.  The problem is treating interactive queries (Which should be fast) from "server" or computation queries (which can be slow, and take a while anyway).  Seems that even small installations or applications might benefit from being able to prioritize the various types of connections, i.e. what the database is being used for in each case.

 

If you're a user and agree, please post.  If you're someone from microsoft and agree, please post as well!  It would be good to get a bunch of people pushing for this.

 

Steve

 

 

4 Replies

@StevenHanderson 

See Editions and supported features of SQL Server 2019 (15.x) => RDBMS scalability and performance

 

(I/O) Resource Governor is only available in Enterprise Edition.

 

Olaf

What I'm advocating is that Microsoft change its releases (i.e. change its mind) so that it is included in the Standard licensed version.
And you may want to get such an Enterprise feature also in the free Express Edition?
You can post feature requests at Azure Feedback, see
https://docs.microsoft.com/en-us/sql/sql-server/sql-server-get-help?view=sql-server-ver15
Hmm - it's unclear where to provide feedback / feature requests on the SQL Server product itself, and not the Azure product or Documentation aspects. I'm not using Azure, just licensing the SQL Server via the Standard license (or perhaps via a site license, I'm not sure).