O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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:

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

The sample classifier function ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required