Microsoft SQL Server 2014 Unleashed

Modifying a Classifier Function

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:

Click here to view code image

ALTER RESOURCE GOVERNOR  WITH (CLASSIFIER_FUNCTION = NULL);ALTER RESOURCE GOVERNOR RECONFIGURE;

The sample classifier function ...