title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | helpviewer_keywords | |
---|---|---|---|---|---|---|---|---|---|
Configure Resource Governor Using a Template |
Learn how to configure Resource Governor by using a template that is provided in SQL Server Management Studio. You must have the CONTROL SERVER permission. |
WilliamDAssafMSFT |
wiassaf |
03/16/2017 |
sql |
performance |
conceptual |
|
[!INCLUDE SQL Server SQL MI] You can configure Resource Governor by using a template that is provided in [!INCLUDEssManStudioFull].
-
Before you begin: Permissions
-
To create a workload group, using: a template
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.
The resource governor [!INCLUDEtsql] statements in the template require CONTROL SERVER permission.
To configure resource governor by using a template in [!INCLUDEssManStudioFull]
-
In [!INCLUDEssManStudioFull], on the View menu, click Template Explorer.
-
In Template Explorer, expand Resource Governor, and then double-click Configure Resource Governor.
-
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.
-
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.
-
To save the changes that you make to the template, click OK.
-
To run the query, click Execute.
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)