You can set state-specific concurrency limits for system throttles, virtual partition throttles, or workload group throttles to override the default concurrency limit for a state. For example, you may want to raise the concurrency limit of a system throttle during a low-traffic state, and lower the concurrency limit during a high-traffic state.
- Edit or create a ruleset.
- From the ruleset toolbar, click Throttles.
- Select a system throttle, virtual partition throttle, or a workload group throttle or create one.
- Click the State Specific Settings 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] 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.
- Click OK.
- Next to a state name, click
- Click Save.