Skip to content

sys-resource-governor-configuration-transact-sql.md

Latest commit

 

History

History
65 lines (50 loc) · 3.07 KB

sys-resource-governor-configuration-transact-sql.md

File metadata and controls

65 lines (50 loc) · 3.07 KB
title sys.resource_governor_configuration (Transact-SQL)
description sys.resource_governor_configuration (Transact-SQL)
author rwestMSFT
ms.author randolphwest
ms.reviewer dfurman
ms.date 02/10/2025
ms.service sql
ms.subservice system-objects
ms.topic reference
f1_keywords
sys.resource_governor_configuration_TSQL
sys.resource_governor_configuration
resource_governor_configuration_TSQL
resource_governor_configuration
helpviewer_keywords
sys.resource_governor_configuration catalog view
dev_langs
TSQL

sys.resource_governor_configuration (Transact-SQL)

[!INCLUDE sql-asdbmi]

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: [!INCLUDEssSQL14] and later.

The maximum number of outstanding I/O requests per volume.

Remarks

The catalog view displays resource governor configuration as stored in metadata. To see the currently effective configuration, use sys.dm_resource_governor_configuration.

Permissions

Requires the VIEW ANY DEFINITION permission to view contents.

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;

Related content