Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

sys.resource_governor_configuration (Transact-SQL)

Applies To: SQL Server 2014, SQL Server 2016 Preview

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

Returns the stored Resource Governor state.

Applies to: SQL Server (SQL Server 2008 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

The maximum number of outstanding I/O per volume.

Applies to: SQL Server 2014 through SQL Server 2016.

The catalog view displays the Resource Governor configuration as stored in metadata. To see the in-memory configuration use the corresponding dynamic management view.

Requires VIEW ANY DEFINITION permission to view contents, requires CONTROL SERVER permission to change contents.

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

Community Additions

ADD
Show:
© 2015 Microsoft