You can use throttles to limit the number of queries running at one time.
- Edit or create a ruleset.
- From the ruleset toolbar, click Throttles.
- Next to Throttles, click .
- Enter a name.
- Create a WHERE clause and select attributes from the list for the workload predicate. When specifying the predicate, you can use existing UDFs, SQL operators, workload management attributes, and AND and OR conjunctions.
Do one of the following to specify a concurrency limit:
Option Description Maximum concurrency Allows the number of concurrent queries you specify to run. Queries submitted after the limit is reached are queued. Deny access to new queries Rejects new queries.
- Click Save.