Disable Resource Governor

THIS TOPIC APPLIES TO: yesSQL ServernoAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

You can disable the Resource Governor by using either SQL Server Management Studio or Transact-SQL.

Before You Begin

Disabling the Resource Governor has the following results:

  • The classifier function is not run.

  • All new connections are automatically classified into the default workload group.

  • System-initiated requests are classified into the internal workload group.

  • All existing workload group and resource pool settings are reset to their default values. In this case, no events are fired when limits are reached.

  • Normal system monitoring is not affected.

  • Configuration changes can be made, but the changes do not take effect until the Resource Governor is enabled.

  • Upon restarting SQL Server, the Resource Governor will not load its configuration, but instead will have only the default and internal workload groups and resource pools.

Limitations and Restrictions

You cannot use the ALTER RESOURCE GOVERNOR statement to disable Resource Governor when in a user transaction.

Permissions

Disabling the Resource Governor requires CONTROL SERVER permission.

Disable Resource Governor Using Object Explorer

To disable the Resource Governor by using Object Explorer

  1. In SQL Server Management Studio, open Object Explorer and recursively expand the Management node down to Resource Governor.

  2. Right-click Resource Governor, and then click Disable.

Disable Resource Governor Using Resource Governor Properties

To disable the Resource Governor by using the Resource Governor Properties page

  1. In SQL Server Management Studio, open Object Explorer and recursively expand the Management node down to Resource Governor.

  2. Right-click Resource Governor and then click Properties, this opens the Resource Governor Properties page.

  3. Click the Enable Resource Governor check box, ensure that the box is not selected, and then click OK.

Disable Resource Governor Using Transact-SQL

To disable the Resource Governor by using Transact-SQL

  1. Run the ALTER RESOURCE GOVERNOR DISABLE statement.

Example (Transact-SQL)

The following example enables the Resource Governor.

ALTER RESOURCE GOVERNOR DISABLE;  
GO  

See Also

Resource Governor
Enable Resource Governor
Resource Governor Resource Pool
Resource Governor Workload Group
Resource Governor Classifier Function
ALTER RESOURCE GOVERNOR (Transact-SQL)