Enable Resource Governor

The Resource Governor is turned off by default. You can enable the Resource Governor by using either SQL Server Management Studio or Transact-SQL.

Before you begin: Limitations and Restrictions, Permissions
To enable Resource Governorn, using: Object Explorer, Resource Governor Properties, Transact-SQL

Before You Begin

Enabling the resource governor has the following results:

The classifier function is run for new connections so that their workloads can be assigned to workload groups.
The resource limits that are specified in the Resource Governor configuration are honored and enforced.
Requests that existed before enabling Resource Governor are affected by any configuration changes that were made when the Resource Governor was disabled.

[Top]

You cannot use the ALTER RESOURCE GOVERNOR statement to enable Resource Governor when in a user transaction.

[Top]

Enabling the Resource Governor requires CONTROL SERVER permission.

[Top]

To enable the Resource Governor by using Object Explorer

In SQL Server Management Studio, open Object Explorer and recursively expand the Management node down to Resource Governor.
Right-click Resource Governor, and then click Enable.

[Top]

To enable the Resource Governor by using the Resource Governor Properties page

In SQL Server Management Studio, open Object Explorer and recursively expand the Management node down to Resource Governor.
Right-click Resource Governor and then click Properties, this opens the Resource Governor Properties page.
Click the Enable Resource Governor check box, and then click OK.

[Top]

To enable the Resource Governor by using Transact-SQL

The following example enables the Resource Governor.

ALTER RESOURCE GOVERNOR RECONFIGURE;
GO

[Top]