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 ...
Get Microsoft® SQL Server 2012 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
