Set Concurrency Limits | Teradata Connector | QueryGrid - Tuning Query Concurrency on Teradata Vantage - Teradata QueryGrid

Teradata® QueryGrid™ Installation and User Guide

Teradata QueryGrid
Release Number
July 2022
English (United States)
Last Update
Product Category
Analytical Ecosystem
  1. From the Workload Designer view, select "" to create a new ruleset.
  2. Enter the name of the ruleset and optionally a description for the ruleset.
  3. Select Save.
  4. Select Throttles.
  5. Next to System Throttles, select the "".
  6. From the General tab, enter a name and optionally a description for the throttle.
  7. Select Save.
  8. Select the Classification tab.
  9. Select Target from the list and select 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 select 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. Select OK.
  13. Select Save.
  14. Select the State Specific Settings tab.
  15. Under Default Settings, select the box and enter the number of queries to permit simultaneously.
  16. Do one of the following:
    • Select Delay to place queries exceeding the limit in a delay queue.
    • Select Reject.
  17. Select Save.
  18. Do the following to activate the ruleset:
    1. From the Workload Designer view, select "" next to the ruleset that you want and select Make Active.