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 - Working with Resource Governor

 

 

Resource Governor Configuration

 

CheckBox 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 btnAddItem button. To refresh the function list, click the btnRefreshList 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 iconPlus add a new resource pool, iconMinus 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.

 

CheckBox 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 iconPlus add a new workload group, iconMinus delete the selected workload group, or export the list to any of supported output file formats.

 

 

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