Workload group throttles are available in Teradata Database 14.10 and later.
- Edit or create a ruleset.
- From the ruleset toolbar, click Throttles.
-
Next to Workload Group Throttles, click
.
- Enter a name.
- [Optional] Enter a description.
- Select the virtual partition to which the workloads belong (SLES 11 systems only).
-
In the Available Workloads box, select one or more workloads and click
to move them to the Workloads in this Group box.
- Click Save.
- Click the State Specific Settings tab.
-
Under Default Settings, do one of the following:
Concurrency Limit Description Unlimited Under Concurrency Limit, select Unlimited. Limited Select Delay and enter a concurrency limit number in the box. -
[Optional] To override the default settings for a state, do the following:
-
Next to a state name, click
.
- Select Create State Specific Settings.
- If you do not want to limit the concurrent queries for this state, select Unlimited under Concurrency Limit.
- If you want to limit the concurrent queries for this state, select Delay and enter a concurrency limit number in the box.
- Click OK.
-
Next to a state name, click
- Click Save.