sys.resource_governor_configuration (Transact-SQL)
Applies to:
SQL Server
Returns the stored Resource Governor state.
Column name | Data type | Description |
---|---|---|
classifier_function_id | int | The ID of the classifier function as it is stored in the metadata. Is not nullable. Note This function is used to classify new sessions and uses rules to route the workload to the appropriate workload group. For more information, see Resource Governor. |
is_enabled | bit | Indicates the current state of the Resource Governor: 0 = Resource Governor is not enabled. 1 = Resource Governor is enabled. 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
The catalog view displays the Resource Governor configuration as stored in metadata. To see the in-memory configuration use the corresponding dynamic management view.
Permissions
Requires VIEW ANY DEFINITION permission to view contents, requires CONTROL SERVER permission to change contents.
Examples
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
See Also
Resource Governor Catalog Views (Transact-SQL)
Catalog Views (Transact-SQL)
sys.dm_resource_governor_configuration (Transact-SQL)
Resource Governor
Visszajelzés
https://aka.ms/ContentUserFeedback.
Hamarosan elérhető: 2024-ben fokozatosan kivezetjük a GitHub-problémákat a tartalom visszajelzési mechanizmusaként, és lecseréljük egy új visszajelzési rendszerre. További információ:Visszajelzés küldése és megtekintése a következőhöz: