Resource Governor Workload Group : Request_MAX_CPU_TIME_SEC

sakuraime 2,321

what's the meaning of the workload group setting : Request_MAX_CPU_TIME_SEC??

May I understand if set Request_MAX_CPU_TIME_SEC=1 for that workload group , if the login in that workload group execute a query need 10s CPU time , the query can't run ????

1 answer

YufeiShao-msft 7,061 Reputation points

2021-10-06T02:59:12.91+00:00

Hi @sakuraime ，

Request_MAX_CPU_TIME_SEC： specifies the maximum amount of CPU time, in seconds, that a request can use
By default, Resource Governor will not prevent a request from continuing if the maximum time is exceeded, however, an event will be gengerated
Please sign in to rate this answer.
sakuraime 2,321 Reputation points

2021-10-06T05:18:37.35+00:00

thanks . and so what's the actual use case for this setting?

YufeiShao-msft 7,061 Reputation points

2021-10-06T05:53:54.26+00:00

I'll add that in Microsoft SQL Server 2014, 2016 and 2017, it will be like I said, value must be 0 or a positive integer. The default setting for value is 0, which means unlimited.
and from 2017, Trace Flag(TF) 2422 is enabled, and if a request exceeds the maximum time set by REQUEST_MAX_CPU_TIME_SEC, then the request is aborted. Additionally, you may receive an error message 10961
the syntax:
https://learn.microsoft.com/en-us/sql/t-sql/statements/create-workload-group-transact-sql?view=sql-server-ver15

sakuraime 2,321 Reputation points

2021-10-06T06:32:33.29+00:00

so it's used with a traceflag 2422 .

YufeiShao-msft 7,061 Reputation points

2021-10-06T07:07:49.54+00:00

yes, you can, Request_MAX_CPU_TIME_SEC=value you can decide for yourself, and Trace Flag(TF) 2422 will help abort the request if the CPU usage exceeds the maximum configured limit for the workload group.

YufeiShao-msft 7,061 Reputation points

2021-10-26T08:02:33.48+00:00

about alter workload group:https://learn.microsoft.com/en-us/sql/t-sql/statements/alter-workload-group-transact-sql?view=sql-server-ver15#examples

Could you please validate all the answers so far and provide any update?
If all of them are not working or helpful, please provide more sample data or details about your issue.
Please remember to accept the answers if they helped. Your action would be helpful to other users who encounter the same issue and read this thread.

YufeiShao-msft 7,061 Reputation points

2021-10-28T09:40:43.983+00:00

If the reply above was helpful please mark as accepted answer so it can be helpful for other community members with same questions.
Sign in to comment