sys.dm_resource_governor_configuration (Transact-SQL)
Applies to: 
SQL Server
Azure SQL Managed Instance
Returns a row that contains the currently effective resource governor configuration.
| Column name | Data type | Description |
|---|---|---|
classifier_function_id |
int | The object ID of the currently used classifier function in sys.objects. Returns 0 if no classifier function is being used. 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_pending |
bit | Indicates whether or not changes to resource governor configuration were made but have not been applied to the currently effective configuration using ALTER RESOURCE GOVERNOR RECONFIGURE. The changes that require resource governor reconfiguration include:- Create, modify, or delete a resource pool. - Create, modify, or delete a workload group. - Specify or remove a classifier function. - Set or remove a limit on the maximum number of outstanding I/O operations per volume. The value returned is one of: 0 - A reconfiguration is not required. 1 - A reconfiguration 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. Not nullable. |
max_outstanding_io_per_volume |
int | Applies to: SQL Server 2014 (12.x) and later. The maximum number of outstanding I/O operations per volume. |
Remarks
This dynamic management view shows the currently effective configuration. To see the stored configuration metadata, use sys.resource_governor_configuration.
Examples
The following example shows how to get and compare the stored metadata values and the currently effective values of resource governor configuration.
USE master;
-- Get the stored metadata
SELECT OBJECT_SCHEMA_NAME(classifier_function_id) AS classifier_function_schema_name,
OBJECT_NAME(classifier_function_id) AS classifier_function_name
FROM sys.resource_governor_configuration;
-- Get the currently effective configuration
SELECT OBJECT_SCHEMA_NAME(classifier_function_id) AS classifier_function_schema_name,
OBJECT_NAME(classifier_function_id) AS classifier_function_name
FROM sys.dm_resource_governor_configuration;
Permissions
Requires the VIEW SERVER STATE permission.
Permissions for SQL Server 2022 and later
Requires the VIEW SERVER PERFORMANCE STATE permission on the server.