Skip to content

configure-resource-governor-using-a-template.md

Latest commit

 

History

History
56 lines (42 loc) · 3.45 KB

configure-resource-governor-using-a-template.md

File metadata and controls

56 lines (42 loc) · 3.45 KB
title Configure Resource Governor Using a Template | Microsoft Docs
ms.custom
ms.date 03/16/2017
ms.prod sql
ms.reviewer
ms.technology performance
ms.topic conceptual
helpviewer_keywords
Resource Governor, templates
ms.assetid f342dec2-d1d6-483e-b44e-98eb7d168b5e
author julieMSFT
ms.author jrasnick

Configure Resource Governor Using a Template

[!INCLUDEappliesto-ss-asdbmi-xxxx-xxx-md] You can configure Resource Governor by using a template that is provided in [!INCLUDEssManStudioFull].

Before You Begin

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 user-defined function that routes new connections to either the default group or the workload group that you create.

Permissions

The resource governor [!INCLUDEtsql] statements in the template require CONTROL SERVER permission.

Configure Resource Governor Using a Template

To configure resource governor by using a template in [!INCLUDEssManStudioFull]

  1. In [!INCLUDEssManStudioFull], on the View menu, click Template Explorer.

  2. In Template Explorer, expand Resource Governor, and then double-click Configure Resource Governor.

  3. In Connect to Database Engine, enter the required information, and then click OK. The template Configure Resource Governor.sql is provided 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, press CTRL+SHIFT+M. In the Specify Values for Template Parameters window, enter the values that you want to use.

  5. To save the changes that you make to the template, click OK.

  6. To run the query, click Execute.

See Also

Resource Governor
Enable Resource Governor
Resource Governor Resource Pool
Resource Governor Workload Group
Resource Governor Classifier Function
View Resource Governor Properties
CREATE RESOURCE POOL (Transact-SQL)
CREATE WORKLOAD GROUP (Transact-SQL)
CREATE FUNCTION (Transact-SQL)
ALTER RESOURCE GOVERNOR (Transact-SQL)