Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Will I need to reboot my server or will it pick up the changes and start encorcing it on the fly?

Will existing long running queries be affected?

share|improve this question
up vote 2 down vote accepted

It only applies to new connections once you enable it. It does not affect existing connections.

To take effect on new connections, no, you shouldn't have to restart the instance.

Also, note that actual resource governing only kicks in when there is contention for a resource (i.e., CPU).

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.