Example: Limiting the Number of Queries That Can Run Concurrently

Teradata® Viewpoint User Guide

prodname
Teradata Viewpoint
Teradata Workload Management
vrm_release
16.20
category
User Guide
featnum
B035-2206-107K
Suppose you want to improve the system throughput by limiting the number of queries that can run concurrently on a system to never exceed three queries. To do this, place any queries that exceed this limit in a delay queue. When one query completes, the next query in the queue starts executing.
  1. Select a ruleset to edit.
    1. Open the Workload Designer portlet and the Workload Designer view.
    2. From the For System list, select PROD1.
    3. In the local Working section, click the ruleset name, FILTERS/THROTTLES.
  2. Create a new system throttle.
    1. From the ruleset toolbar, click Throttles.
    2. Next to System Throttles, click .
    3. Enter the name of the throttle, in this case Concurrent Queries.
    4. Select the Rule Type option Collective.
    5. Click Save.
  3. Add classification criteria for the system throttle to apply to all users.
    1. Click the Classification tab.
    2. From the Add Classification Criteria list, select Request Source.
    3. Click Add. The Edit Request Source Criteria dialog box appears.
    4. From the Source Type list, select Username.
    5. From the Usernames list, select All.
    6. Click Include.
    7. Click OK.
    8. Click Save.
  4. Add throttle limits to allow only three queries to execute at a time.
    1. Click the State Specific Settings tab.
    2. Under Default Settings, type 3 in the box to set the concurrency limit.
    3. Select Delay to place queries exceeding the limit in a delay queue.
    4. Click Save.
  5. Activate the ruleset.
    1. Go back to the Workload Designer view.
    2. For the FILTERS/THROTTLES ruleset, click and select Make Active.
  6. [Optional] Review the queries in the delay queue.
    1. Open the Workload Monitor portlet.
    2. Click "" in the portlet frame and select Settings.
    3. Click the Systems tab.
    4. From the Systems list, select PROD1.
    5. Click OK.
    6. From the toolbar, click on Delayed Requests to view metrics for requests that were delayed by throttles.
    7. Click on the Session ID to view more details.