Search code examples
sql-serversql-server-2012resource-governor

How to view current Resource Governor Classification Function


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


Solution

  • 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;