Define a throttle for a workload when you create or edit a workload in the Workloads view. When you set a throttle for a workload, any query that is classified into this workload is subject to the throttle you create.
- Edit or create a ruleset.
- From the ruleset toolbar, click Workloads.
- Edit or create a workload.
- Click the Throttles tab.
-
Under Default Settings, do one of the following:
Concurrency Limit Description Unlimited Under Concurrency Limit, select Unlimited. Limited - Under Concurrency Limit, enter a concurrency limit number in the box, and select either Delay or Reject.
- [Optional] If you selected Delay, have a SLES 11 EDW system, and are using Teradata Database 16.0 and later, you can select Enable Flex Throttles to apply flex throttles to the workload.
-
[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, enter a concurrency limit number in the box, and select either Delay or Reject.
- [Optional] If you selected Delay, have a SLES 11 EDW system, and are using Teradata Database 16.0 and later, you can select Enable Flex Throttles to apply flex throttles to when the workload is in that state.
- Click OK.
-
Next to a state name, click
- [Optional] If the workload is a member of a workload group throttle, view throttle limits for the group throttle and for each workload that is a member of the group.
- Click Save.