Example: Limiting the Number of Queries That Can Run Concurrently - Teradata Viewpoint - Teradata Workload Management

Teradata® Viewpoint User Guide - 23.04
Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata Viewpoint
Teradata Workload Management
Release Number
23.04
Published
April 2023
Language
English (United States)
Last Update
2023-05-05
dita:mapPath
cxb1678987903668.ditamap
dita:ditavalPath
tky1501004671670.ditaval
dita:id
B035-2206
Product Category
Analytical Ecosystem
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.