What is the maximum limit that the dispatcher count can have in Teradata Adapter Services?
Article ID: KB0091988
Updated On:
| Products | Versions |
|---|---|
| TIBCO Adapter for Teradata | - |
| Not Applicable | - |
Description
Resolution:
The theoretical limit of the dispatcher count will depend on the operating system that runs the adapter. The code specific limit is an unsigned 32 bit with a limit of 2^32 (4294967294).However, the adapter will slow down to a crawl before even that limit is reached because of other restrictions such as memory limits. To find out the optimal value of the dispatcher count for the environment in which the adapter is running, a series of tests has to be done.
Also in case using EMS server, ensure that enough memory space is available on the EMS server.Please refer to the EMS documentation for setting the EMS server maximum memory size.
It is always advisable not to keep the dispatcher count at a higher rate because of the following reason:
As the dispatcher count increases the number of Teradata Sessions in the session pool increases, this will lead the adapter to allocate a minimum set of resources for every set of threads irrespective of the usage of the threads.
Please refer to the Teradata Adapter user guide Chapter 7 Advanced Topics -- Performance Tuning section for more details on the Dispatcher count and the factors which affect it.
The theoretical limit of the dispatcher count will depend on the operating system that runs the adapter. The code specific limit is an unsigned 32 bit with a limit of 2^32 (4294967294).However, the adapter will slow down to a crawl before even that limit is reached because of other restrictions such as memory limits. To find out the optimal value of the dispatcher count for the environment in which the adapter is running, a series of tests has to be done.
Also in case using EMS server, ensure that enough memory space is available on the EMS server.Please refer to the EMS documentation for setting the EMS server maximum memory size.
It is always advisable not to keep the dispatcher count at a higher rate because of the following reason:
As the dispatcher count increases the number of Teradata Sessions in the session pool increases, this will lead the adapter to allocate a minimum set of resources for every set of threads irrespective of the usage of the threads.
Please refer to the Teradata Adapter user guide Chapter 7 Advanced Topics -- Performance Tuning section for more details on the Dispatcher count and the factors which affect it.
Issue/Introduction
What is the maximum limit that the dispatcher count can have in Teradata Adapter Services?
Feedback
Yes
No
Powered by
