Skip to content

Latest commit

 

History

History
82 lines (55 loc) · 3.14 KB

disable-resource-governor.md

File metadata and controls

82 lines (55 loc) · 3.14 KB
title description author ms.author ms.reviewer ms.date ms.service ms.subservice ms.topic helpviewer_keywords monikerRange
Disable Resource Governor
Learn how to disable resource governor using either SQL Server Management Studio or Transact-SQL.
WilliamDAssafMSFT
wiassaf
dfurman
01/02/2025
sql
performance
how-to
Resource Governor, disabling
>= sql-server-2016 || >= sql-server-linux-2017 || = azuresqldb-mi-current

Disable resource governor

[!INCLUDE SQL Server SQL MI]

You can disable resource governor using either [!INCLUDEssManStudioFull] or [!INCLUDEtsql].

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 [[!INCLUDEssManStudioFull]](../../ssms/download-sql-server-management-studio-ssms.md):

  1. In [!INCLUDEssManStudioFull], 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 [!INCLUDEssManStudioFull], 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 [!INCLUDEtsql], execute the ALTER RESOURCE GOVERNOR DISABLE statement.

Example

The following example disables resource governor.

ALTER RESOURCE GOVERNOR DISABLE;

Related content