If you need to make a change to the classifier function, it’s important to note that the function cannot be dropped or altered while it is marked as the classifier function for the Resource Governor. Before you can modify or drop the classifier function, you first need to disable Resource Governor. Alternatively, you can replace the classifier function with another by running the
ALTER RESOURCE GOVERNOR command and passing it a different
CLASSIFIER_FUNCTION name. You can also simply disable the current classifier function by executing the following command:
ALTER RESOURCE GOVERNOR WITH (CLASSIFIER_FUNCTION = NULL);ALTER RESOURCE GOVERNOR RECONFIGURE;
The sample classifier function ...