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.