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

title	sys.resource_governor_configuration (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/14/2017
ms.prod	sql-non-specified
ms.reviewer
ms.suite
ms.technology	database-engine
ms.tgt_pltfrm
ms.topic	language-reference
f1_keywords	sys.resource_governor_configuration_TSQL sys.resource_governor_configuration resource_governor_configuration_TSQL resource_governor_configuration
dev_langs	TSQL
helpviewer_keywords	sys.resource_governor_configuration catalog view
ms.assetid	89099668-1dc6-4b07-9d8b-49bc95c7bfc0
caps.latest.revision	24
author	JennieHubbard
ms.author	jhubbard
manager	jhubbard

sys.resource_governor_configuration (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx_md]

Returns the stored Resource Governor state.

Applies to: [!INCLUDEssNoVersion] ([!INCLUDEssKatmai] through current version).

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: [!INCLUDEssSQL14] through [!INCLUDEssCurrent]. 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