ALTER RESOURCE GOVERNOR RECONFIGURE while server is in use

Question

ALTER RESOURCE GOVERNOR RECONFIGURE while server is in use

thermanson

Mr or Mrs. 500

Points: 523
More actions
April 14, 2010 at 8:41 am

#221326

I have made changes to my CLASSIFIER_FUNCTION and would now like to invoke the changes. I realized I have to issue the ALTER RESOURCE GOVERNOR RECONFIGURE command to do this. My question is can I do this while the server is in use. We strive for high availability on this server, so I'd like to avoid taking it down to do this change. However it would be much worse if this change made the server unavailable at an unplanned time. I've read MS documentation and many other articles and none has said that it can or cannot be done. Expert advice would be appreciated.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply

kenambrose SSCrazy Points: 2513 More actions · Answer 1

YES, but first you must set the classifier function to null for the governor. then you can alter the function. then you will have to reconfigure the governor to use the revised classifier function.