sys.dm_resource_governor_configuration (Transact-SQL)
Applies to:
SQL Server
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. |
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. |
max_outstanding_io_per_volume | int | Applies to: SQL Server 2014 (12.x) and later. The maximum number of outstanding I/O per volume. |
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.
Permissions for SQL Server 2022 and later
Requires VIEW SERVER PERFORMANCE STATE permission on the server.
See also
Dynamic Management Views and Functions (Transact-SQL)
sys.resource_governor_configuration (Transact-SQL)
Resource Governor
प्रतिक्रिया
https://aka.ms/ContentUserFeedback.
जल्द आ रहा है: 2024 के दौरान हम सामग्री के लिए फीडबैक तंत्र के रूप में GitHub मुद्दों को चरणबद्ध तरीके से समाप्त कर देंगे और इसे एक नई फीडबैक प्रणाली से बदल देंगे. अधिक जानकारी के लिए, देखें:के लिए प्रतिक्रिया सबमिट करें और देखें