2.06 - Tuning Query Concurrency on Teradata Database - Teradata QueryGrid

Teradata® QueryGrid™ Installation and User Guide

Teradata QueryGrid
Release Number
September 2018
English (United States)
Last Update
  1. From the Workload Designer view, click to create a new ruleset.
  2. Enter the name of the ruleset and optionally, a description, for the ruleset.
  3. Click Save.
  4. Click Throttles.
  5. Next to System Throttles, click the .
  6. On the General tab, enter a name and optionally, a description, for the throttle.
  7. Click Save.
  8. Click the Classification tab.
  9. Select Target from the list and click Add.
  10. Select Function from the Target Type list and select TD_SYSFNLIB from the database list.
  11. Enter the name of the function and click Include. The name can be exact or you can use an asterisk (*) as a wildcard to indicate any number of characters. For example, you can use QGInitiator* to create a single throttle that matches both QGInitiatorImport and QGInitiatorExport.
  12. Click OK.
  13. Click Save.
  14. Click the State Specific Settings tab.
  15. Under Default Settings, click the box and enter the number of queries you want to permit simultaneously.
  16. Do one of the following:
    • Select Delay to place queries exceeding the limit in a delay queue.
    • Select Reject.
  17. Click Save.
  18. Do the following to activate the ruleset:
    1. From the Workload Designer view, click next to the ruleset that you want and select Make Active.