Skip to content

disable-resource-governor.md

Latest commit

 

History

History
82 lines (55 loc) · 3.09 KB

disable-resource-governor.md

File metadata and controls

82 lines (55 loc) · 3.09 KB
title Disable Resource Governor
description Learn how to disable resource governor using either SQL Server Management Studio or Transact-SQL.
author WilliamDAssafMSFT
ms.author wiassaf
ms.reviewer dfurman
ms.date 01/02/2025
ms.service sql
ms.subservice performance
ms.topic how-to
helpviewer_keywords
Resource Governor, disabling
monikerRange >= 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 SQL Server Management Studio (SSMS):

  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