Export (0) Print
Expand All

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.

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]

Limitations and Restrictions

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

[Top]

Permissions

Enabling the Resource Governor requires CONTROL SERVER permission.

[Top]

To enable the Resource Governor by using Object Explorer

  1. In SQL Server Management Studio, open Object Explorer and recursively expand the Management node down to Resource Governor.

  2. Right-click Resource Governor, and then click Enable.

[Top]

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

  1. In SQL Server Management Studio, open Object Explorer and recursively expand the Management node down to Resource Governor.

  2. Right-click Resource Governor and then click Properties, this opens the Resource Governor Properties page.

  3. Click the Enable Resource Governor check box, and then click OK.

[Top]

To enable the Resource Governor by using Transact-SQL

  1. Run the ALTER RESOURCE GOVERNOR RECONFIGURE statement.

Example (Transact-SQL)

The following example enables the Resource Governor.

ALTER RESOURCE GOVERNOR RECONFIGURE;
GO

[Top]

Community Additions

ADD
Show:
© 2014 Microsoft