sys.resource_governor_configuration (Transact-SQL)
Returns the stored Resource Governor state.
|
Column name |
Data type |
Description |
|---|---|---|
|
classifier_function_id |
int |
The ID of the classifier function as it is stored in the metadata. Is not nullable. Note This function is used to classify new sessions and uses rules to route the workload to the appropriate workload group. For more information, see Resource Governor. |
|
is_enabled |
bit |
Indicates the current state of the Resource Governor:
Is not nullable. |
The following example shows how to get and compare the stored metadata values and the in-memory values of the Resource Governor configuration.
USE master GO -- Get the stored metadata. SELECT object_schema_name(classifier_function_id) AS 'Classifier UDF schema in metadata', object_name(classifier_function_id) AS 'Classifier UDF name in metadata' FROM sys.resource_governor_configuration GO -- Get the in-memory configuration. SELECT object_schema_name(classifier_function_id) AS 'Active classifier UDF schema', object_name(classifier_function_id) AS 'Active classifier UDF name' FROM sys.dm_resource_governor_configuration GP
