Resource Governor Workload Group : Request_MAX_CPU_TIME_SEC

sakuraime 2,336 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.
14,487 questions
0 comments No comments
{count} votes

1 answer

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


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.