Online Documentation for SQL Manager for SQL server

Working with Resource Governor

The Resource Governor window consists of three basic areas: Resource Governor Configuration, Resource Pools and Workload Groups.

Resource Governor Configuration

Resource Governor enabled

This option enables/disables Resource Governor.

Classifier function

Use the drop-down list to select the user-defined function whose return values will be used for classifying sessions that are then routed to the appropriate workload group.

To create a new function, click the button. To refresh the function list, click the button.

Note: If there are pending changes in Resource Governor configuration, you will need to reconfigure Resource Governor to apply these changes using the corresponding Reconfigure button.

The Resource Pools list displays the resource pools as a grid with the following columns: Resource Pool Name, Minimum CPU (%), Maximum CPU (%), Minimum Memory (%), Maximum Memory (%). If more convenient, you can change the order of the columns by dragging their headers horizontally.

Click a column caption to sort items by values of this column in the ascending or the descending mode.

To set a value, click in the cell you need, and type in the required value, or use the spinner control for this purpose.

Right-click an item within the Resource Pools list to call the context menu allowing you to add a new resource pool, delete the selected resource pool, or export the list to any of supported output file formats.

The Workload Groups list displays the workload groups as a grid with the following columns: Workload Group Name, Importance, Max Memory Grant for Request (%), Max CPU Use Limit for Request (sec), Memory Grant Time-out for Request (sec), Max Degree of Parallelism, Max Number of Requests, Resource Pool. If more convenient, you can change the order of the columns by dragging their headers horizontally.

Click a column caption to sort items by values of this column in the ascending or the descending mode.

Show all workload groups

If this option is selected, all workload groups are displayed in the list, otherwise only those associated with the currently selected resource pool.

To set a value, click in the cell you need, and type in the required value, or use the spinner control for this purpose.

To associate a workload group with a resource pool, click in a cell of the Resource Pool column and select the resource pool you need from the drop-down list.

Right-click an item within the Workload Groups list to call the context menu allowing you to add a new workload group, delete the selected workload group, or export the list to any of supported output file formats.

To apply changes, use the Compile item available within the Navigation bar and toolbar.