sys.dm_resource_governor_configuration (Transact-SQL)
Returns a row that contains the current in-memory configuration state of Resource Governor.
|
Column name |
Data type |
Description |
||
|---|---|---|---|---|
|
classifier_function_id |
int |
The ID of the classifier function that is currently used by Resource Governor. Returns a value of 0 if no function is being used. Is not nullable.
|
||
|
is_reconfiguration_pending |
bit |
Indicates whether or not changes to a group or pool were made with the ALTER RESOURCE GOVERNOR RECONFIGURE statement but have not been applied to the in-memory configuration. The value returned is one of:
Is not nullable. |
Note
This dynamic management view shows the in-memory configuration. To see the stored configuration metadata, use the corresponding catalog view.
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 go
