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.
Limit SQL Server CPU usage for Login
Using SQL Server 2016 Standard Edition. Is there any way to limit CPU usage for a specific login?
2 additional answers
Sort by: Most helpful
-
Tom Phillips 17,716 Reputation points
2021-07-27T19:48:58.093+00:00 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.
-
CathyJi-MSFT 21,096 Reputation points Microsoft Vendor
2021-07-28T01:49:56.737+00:00 Hi @AlphonseG ,
>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.