sys.dm_resource_governor_configuration (Transact-SQL)


Updated: June 10, 2016

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Returns a row that contains the current in-memory configuration state of Resource Governor.

Column nameData typeDescription
classifier_function_idintThe 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.
is_reconfiguration_pendingbitIndicates 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.
max_outstanding_io_per_volumeintApplies to: SQL Server 2014 through SQL Server 2016.

The maximum number of outstanding I/O per volume.

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;  
-- Get the stored metadata.  
object_schema_name(classifier_function_id) AS 'Classifier UDF schema in metadata',   
object_name(classifier_function_id) AS 'Classifier UDF name in metadata'  
-- Get the in-memory configuration.  
object_schema_name(classifier_function_id) AS 'Active classifier UDF schema',   
object_name(classifier_function_id) AS 'Active classifier UDF name'  

Requires VIEW SERVER STATE permission.

Dynamic Management Views and Functions (Transact-SQL)
sys.resource_governor_configuration (Transact-SQL)
Resource Governor

Community Additions