Skip to content

enable-resource-governor.md

Latest commit

 

History

History
81 lines (53 loc) · 3.18 KB

enable-resource-governor.md

File metadata and controls

81 lines (53 loc) · 3.18 KB
title Enable Resource Governor
description Learn how to enable resource governor using either SQL Server Management Studio or Transact-SQL.
author WilliamDAssafMSFT
ms.author wiassaf
ms.reviewer dfurman
ms.date 04/09/2025
ms.service sql
ms.subservice performance
ms.topic how-to
helpviewer_keywords
Resource Governor, enabling
monikerRange >= sql-server-2016 || >= sql-server-linux-2017 || = azuresqldb-mi-current

Enable resource governor

[!INCLUDE SQL Server SQL MI]

Resource governor is turned off by default. You can enable resource governor using either [!INCLUDEssManStudioFull] or [!INCLUDEtsql].

For configuration and monitoring examples and to learn resource governor best practices, see Tutorial: Resource governor configuration examples and best practices.

Enabling resource governor has the following results:

  • The classifier function is executed for new connections so that workloads can be assigned to workload groups.
  • The resource limits that are specified in resource governor configuration are honored and enforced.

Limitations

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

Permissions

Enabling resource governor requires the CONTROL SERVER permission.

Enable resource governor using Object Explorer in SQL Server Management Studio

To enable 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 Enable.

Enable resource governor using resource governor properties

To enable resource governor by 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. Select the Enable Resource Governor check box and select OK.

Enable resource governor using Transact-SQL

To enable resource governor using [!INCLUDEtsql], execute the ALTER RESOURCE GOVERNOR RECONFIGURE statement.

Example

The following example enables resource governor and makes all prior resource governor configuration changes effective.

ALTER RESOURCE GOVERNOR RECONFIGURE;

Related content