| title | Configure Resource Governor Using a Template | |
|---|---|---|
| description | Learn how to configure resource governor by using a template that is provided in SQL Server Management Studio. | |
| author | williamdassafmsft | |
| ms.author | wiassaf | |
| ms.reviewer | dfurman | |
| ms.date | 01/02/2025 | |
| ms.service | sql | |
| ms.subservice | performance | |
| ms.topic | how-to | |
| helpviewer_keywords |
|
|
| monikerRange | >= sql-server-2016 || >= sql-server-linux-2017 || = azuresqldb-mi-current |
[!INCLUDE SQL Server SQL MI]
You can configure resource governor using a template that is provided in [!INCLUDEssManStudioFull].
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.
The resource governor [!INCLUDEtsql] statements in the template require the CONTROL SERVER permission.
To configure resource governor using a template in SQL Server Management Studio (SSMS):
- In [!INCLUDEssManStudioFull], open the View menu and select Template Explorer.
- In Template Explorer, expand Resource governor, and then select Configure Resource governor.
- In Connect to Database Engine, enter the required information, and then select OK. the template
Configure Resource governor.sqlopens 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, use the
Control+Shift+Mkey combination. In the Specify Values for Template Parameters window, enter the values that you want to use. - To populate the template with the values you entered, select OK.
- To execute the query, select Execute.