Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

How to: Configure Resource Governor Using a Template (SSMS)

This topic shows how you can configure Resource Governor by 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 user-defined function that routes new connections to either the default group or the workload group that you create.

NoteNote

For additional examples that show Resource Governor configurations, see Resource Governor Workload Management Scenarios.

To configure Resource Governor by using a template

  1. In SQL Server Management Studio, 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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.