Edit

Share via

Configure resource governor using a template

  • Article

Applies to: SQL Server Azure SQL Managed Instance

You can configure resource governor using a template that is provided in SQL Server Management Studio.

Use the following steps to open and modify a template that creates a resource pool and a workload group for the pool. In addition, this template enables you to create a classifier function that assigns new connections to either the default group or the workload group that you create.

Permissions

The resource governor Transact-SQL statements in the template require the CONTROL SERVER permission.

Configure resource governor using a template

To configure resource governor using a template in SQL Server Management Studio:

  1. In SQL Server Management Studio, open the View menu and select Template Explorer.
  2. In Template Explorer, expand Resource governor, and then select Configure Resource governor.
  3. In Connect to Database Engine, enter the required information, and then select OK. the template Configure Resource governor.sql opens in the query editor. Use this template to create and configure a resource pool, a workload group, and a classifier function.
  4. To change the values in the template, use the Control+Shift+M key combination. In the Specify Values for Template Parameters window, enter the values that you want to use.
  5. To populate the template with the values you entered, select OK.
  6. To execute the query, select Execute.

Related content