| title | sys.dm_resource_governor_configuration (Transact-SQL) | ||||
|---|---|---|---|---|---|
| description | sys.dm_resource_governor_configuration (Transact-SQL) | ||||
| author | rwestMSFT | ||||
| ms.author | randolphwest | ||||
| ms.reviewer | dfurman | ||||
| ms.date | 02/11/2025 | ||||
| ms.service | sql | ||||
| ms.subservice | system-objects | ||||
| ms.topic | reference | ||||
| f1_keywords |
|
||||
| helpviewer_keywords |
|
||||
| dev_langs |
|
[!INCLUDE sql-asdbmi]
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: [!INCLUDEssSQL14] and later. The maximum number of outstanding I/O operations per volume. |
This dynamic management view shows the currently effective configuration. To see the stored configuration metadata, use sys.resource_governor_configuration.
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;Requires the VIEW SERVER STATE permission.
Requires the VIEW SERVER PERFORMANCE STATE permission on the server.