Resource Governor Workload Group : Request_MAX_CPU_TIME_SEC

sakuraime 2,321 Reputation points
2021-10-05T09:24:18+00:00

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 ????

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,263 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. YufeiShao-msft 7,081 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