Using SQL Server 2016 Standard Edition. Is there any way to limit CPU usage for a specific login?
Using SQL Server 2016 Standard Edition. Is there any way to limit CPU usage for a specific login?
No. But if you cough up the money for a license for Enterprise Edition, you will have Resource Governor at your disposal. But this component is not available in Standard Edition.
Thanks to everyone.
Enterprise is not an option. I'm just the guy that's responsible for the on premises app and database. There is also a web app the connects to the database. The web app is extremely poorly written regarding data access. Like, 130 redundant database calls to load one page. I have no control over that, but I'm the guy that everyone calls when the db becomes non-responsive. I thought that if was some way to limit resources for that user, it would force them to fix it.
Hm, I think it is a good thing that you don't have Enterprise. :-)
While poorly written applications are a pain, I don't think the right way to trigger an improvement is to press the go-slower button on the server. You will have to find the right political path to get that app fixed. (And, yes, that can be a lot more difficult to solve than purely technical problems.)
Thanks. I do agree that it's not the 'right' way. Sometimes, a little of the 'not so right' way can help highlight an issue.
As Erland said, not in Standard edition.
However, SQL Server rarely uses large amount of CPU, unless there is a problem with a query. Rather than try to limit CPU, you should look at fixing the bad queries.
Hi @AlphonseG8302,
Using SQL Server 2016 Standard Edition. Is there any way to limit CPU usage for a specific login?
No, if you upgrade your SQL Server 2016 from standard edition to enterprise edition. You can using SQL Server Resource Governor feature.

SQL Server Resource Governor is a feature that you can use to manage SQL Server workload and system resource consumption. Resource Governor enables you to specify limits on the amount of CPU, physical I/O, and memory that incoming application requests can use.
Please refer to MS document Resource Governor and How To Limit a User’s Resource Usage Using Resource Governor.
If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.
14 people are following this question.