Edit

Share via

Disable resource governor

  • Article

Applies to: SQL Server Azure SQL Managed Instance

You can disable resource governor using either SQL Server Management Studio or Transact-SQL.

Disabling resource governor has the following immediate effects:

  • The classifier function isn't executed when a new connection is opened.
  • New connections are automatically classified into the default workload group.
  • All existing workload group and resource pool settings are reset to their default values.
  • No events are fired when limits are reached.
  • Resource governor configuration changes can be made, but the changes don't take effect until resource governor is enabled.

Limitations

You can't use the ALTER RESOURCE GOVERNOR statement as part of a user transaction.

Permissions

Disabling resource governor requires the CONTROL SERVER permission.

Disable resource governor using Object Explorer in SQL Server Management Studio

To disable resource governor using Object Explorer in SQL Server Management Studio:

  1. In SQL Server Management Studio, open Object Explorer and expand the Management node down to Resource Governor.
  2. From the Resource Governor context menu, select Disable.

Disable resource governor using resource governor properties

To disable resource governor using the resource governor properties page:

  1. In SQL Server Management Studio, open Object Explorer and expand the Management node down to Resource Governor.
  2. From the Resource Governor context menu, select Properties.
  3. Clear the Enable Resource Governor check box and select OK.

Disable resource governor using Transact-SQL

To disable resource governor using Transact-SQL, execute the ALTER RESOURCE GOVERNOR DISABLE statement.

Example

The following example disables resource governor.

ALTER RESOURCE GOVERNOR DISABLE;

Related content