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

Teradata Viewpoint User Guide
Product
Teradata Viewpoint
Release Number
16.00
Published
October 2016
Language
English (United States)
Last Update
2018-03-29
dita:mapPath
fey1467302953244.ditamap
dita:ditavalPath
2206_User_vp_1600_NEW.ditaval.ditaval
dita:id
B035-2206
lifecycle
previous
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.