On the Priority Distribution tab, each cell in the diagram is an allocation group. The size of each cell is proportional to the relative weight and can be adjusted to change the percent of CPU available to each AG. Each column in the diagram is a resource partition. The width of each column is proportional to the relative weight and can be adjusted to change the percent of CPU available to each resource partition.
If you modify the base state on the Priority Distribution tab, the changes are applied to other states provided that no change has been made to any of the other states. After any of the states are changed, the only values that are applied are the changes to system values.
- Edit or create a ruleset.
- From the ruleset toolbar, click Workloads.
- Click the Priority Distribution tab.
- From the State list, select a state.
- For resource partitions, do any of the following:
Option Description View partition details - Hover over any resource partition name.
Edit partition details - Click a resource partition name, and click .
- Enter a system percentage allocation and, optionally, a CPU percentage limit.
Reallocate space between resource partitions - Click a resource partition name, and drag the column resize bar.
Lock or unlock a column - Click a resource partition name and click to lock this column in the diagram, while other cells can be dynamically resized around this column.
- Click a resource partition name and click to unlock this column in the diagram so the allocation changes dynamically with other columns around it.
- For allocation groups, do any of the following:
Option Description View AG details - Hover over any allocation group.
Edit AG details - Click in a cell and click .
- Enter a system percentage allocation and, optionally, a CPU percentage limit.
Reallocate space in a resource partition - Click in a cell and drag the cell resize bar.
Lock or unlock a cell - Click in a cell and click to lock this cell in the diagram, while other cells can be dynamically resized around this cell.
- Click in a cell and click to unlock this cell in the diagram so the allocation changes dynamically with other cells around it.
- [Optional] Under System Values, do any of the following:
- Select CPU Limit and enter a CPU limit to set the maximum percentage of system CPU that Analytics Database can use.
- Select Reserved AWTs and enter a number to set the maximum number of AMP worker tasks that are reserved for tactical workloads.
- Select Max Expedited AWTs and enter a number to set the maximum number of AMP worker tasks that are created on each node.
- Click Save.