Query Concurrency | Teradata Connector | QueryGrid - Query Concurrency on Teradata Vantage - Teradata QueryGrid

Teradata® QueryGrid™ Installation and User Guide

Product
Teradata QueryGrid
Release Number
2.19
Published
July 2022
Language
English (United States)
Last Update
2022-07-28
dita:mapPath
jpf1654813554544.ditamap
dita:ditavalPath
ft:empty
dita:id
lxg1591800469257
Product Category
Analytical Ecosystem

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).

Teradata recommends creating a custom rule in TDWM to set the concurrency limit for these operators, using a range of 6 to 8 concurrent queries under typical circumstances. You can increase this limit to 50 or more queries, but 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. A best practice is 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.