2.10 - Tuning Query Concurrency on Teradata Database - Teradata QueryGrid

Teradata® QueryGrid™ Installation and User Guide

prodname
Teradata QueryGrid
vrm_release
2.10
created_date
September 2019
category
Administration
Configuration
Installation
User Guide
featnum
B035-5991-099K
  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.