If you have created workloads, you can view the Workload Mapping tab to see how the workloads map to allocation groups and resource partitions. Allocation groups and resource partitions determine how much CPU is available to the queries that are running in the listed workloads. The default allocation groups are named L (Low), M (Medium), H (High), R (Rush) and represent levels of priority. These groups are used by the system for console utilities and cannot be deleted.
- Edit or create a ruleset.
- From the ruleset toolbar, click Workloads.
- Click the Workload Mapping tab.
- Do any of the following:
Option Description Create allocation groups - Next to a resource partition name, such as Tactical or Standard, and click .
Create a resource partition - Next to Resource Partitions, click .
Change resource partition for an AG - Drag an allocation group to a different resource partition.
Change AG for a workload - Drag a workload to a different allocation group of same priority in any resource partition.
Rename a resource partition - To the right of a resource partition name, click .
Delete an empty allocation group - To the right of an allocation group name, click .
Delete an empty resource partition - To the right of a resource partition name, click .
- Click Save.