How to view current Resource Governor Classification Function

627 views Asked by At

Is there a way to view what is the current/active Classification Function that the Resource Governor is currently using ?

1

There are 1 answers

0
laylarenee On BEST ANSWER

The classifier function is stored in the sys.resource_governor_configuration table:

select OBJECT_NAME(classifier_function_id) AS [ClassifierFunctionName]
from sys.resource_governor_configuration;