Skip to content

Latest commit

 

History

History
81 lines (53 loc) · 3.23 KB

enable-resource-governor.md

File metadata and controls

81 lines (53 loc) · 3.23 KB
title description author ms.author ms.reviewer ms.date ms.service ms.subservice ms.topic helpviewer_keywords monikerRange
Enable Resource Governor
Learn how to enable resource governor using either SQL Server Management Studio or Transact-SQL.
WilliamDAssafMSFT
wiassaf
dfurman
04/09/2025
sql
performance
how-to
Resource Governor, enabling
>= 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 [[!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 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