Performance Factors - Parallel Transporter

Teradata Parallel Transporter Application Programming Interface Programmer Guide

Product
Parallel Transporter
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-05-15
dita:mapPath
pev1488824663354.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2516
lifecycle
previous
Product Category
Teradata Tools and Utilities

Performance can vary depending on the number of sessions that the Export driver is using. Using too few sessions can limit the data throughput; using too many sessions involves increased session management overhead which can slow down the job. The latter can occur when running against a large Teradata Database configuration as the Export driver’s default setting is to have one session per AMP.

There is no general method to determine the optimal number of sessions to use since there are several factors to consider such as the performance and workload of the Teradata Database, the network performance, and the volume of data being processed. In many cases, using two or four sessions will result in the best performance, but users are encouraged to experiment with several different session configurations to determine the best setting for each Teradata Database configuration.