sys.dm_resource_governor_configuration (Transact-SQL)

sys.dm_resource_governor_configurat...

Switch on low bandwidth view

Community Content

In this section

Statistics Annotations (0)

Click here to expand

Collapse All

Language Filter

SQL Server 2008 Books Online (October 2009)

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. Note: This function is used to classify new requests and uses rules to route these requests to the appropriate workload group. For more information, see Resource Governor Concepts.
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: 0 - A reconfiguration statement is not required. 1 - A reconfiguration statement or server restart is required in order for pending configuration changes to be applied. Note: The value returned is always 0 when Resource Governor is disabled. Is not nullable.

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.

Note:

This function is used to classify new requests and uses rules to route these requests to the appropriate workload group. For more information, see Resource Governor Concepts.

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:

0 - A reconfiguration statement is not required.
1 - A reconfiguration statement or server restart is required in order for pending configuration changes to be applied.

Note:

The value returned is always 0 when Resource Governor is disabled.

Is not nullable.

Remarks

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

Permissions

Requires VIEW SERVER STATE permission.

Reference

Other Resources

Help and Information