Events
Apr 8, 3 PM - May 28, 7 AM
Sharpen your AI skills and enter the sweepstakes to win a free Certification exam
Register now!Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server
Azure SQL Managed Instance
Returns the stored resource governor configuration.
| Column name | Data type | Description |
|---|---|---|
classifier_function_id |
int | The object ID of the classifier function in sys.objects. 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 resource governor: 0 = is not enabled. 1 = is enabled. Not nullable. |
max_outstanding_io_per_volume |
int | Applies to: SQL Server 2014 (12.x) and later. The maximum number of outstanding I/O requests per volume. |
The catalog view displays resource governor configuration as stored in metadata. To see the currently effective configuration, use sys.dm_resource_governor_configuration.
Requires the VIEW ANY DEFINITION permission to view contents.
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;