2.10 - 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

The Workload Designer portlet does not contain a default Teradata Dynamic Workload Manager (TDWM) rule to limit query concurrency for the import and export QueryGrid table operators (such as QGInitiatorImport, QGInitiatorExport, QGRemoteImport, and QGRemoteExport).

It is considered a best practice to create a custom rule in TDWM to set the concurrency limit for these operators. Teradata recommends that you use a range of 6 to 8 concurrent queries under typical circumstances. You can increase this limit to 50 or more queries, but you should keep in mind that when you increase concurrency, there is a cost in terms of query latency. If a rule contains multiple objects of the same type, then the objects are logically tied together with an OR. It is considered a best practice to not include objects other than functions when you create throttle rules for the connector table operators.

For information about TASM throttle rules, see Teradata® Database Workload Management User Guide, B035-1197.

For more detailed information about using Viewpoint Workload Designer, see Teradata® Viewpoint User Guide, B035-2206.