Throughput per query decreases as more concurrent queries are run, but the total throughput of the system increases.
BYNET connection is used between Teradata and the driver node for the following reference data:
2 CPUs, 8GB RAM, 2GB DriverHeapSize, number of threads = 5
| Sessions | CPU Utilization | Throughput |
|---|---|---|
| Single read session | 9.27% | 9.13MB/sec |
| 5 concurrent read sessions | 33.51% | 8.33MB/sec |
| 20 concurrent read sessions | 70.49% | 7.19MB/sec |
| Sessions | CPU Utilization | Throughput |
|---|---|---|
| Single write session | 12.07% | 3.26MB/sec |
| 5 concurrent write sessions | 68.62% | 2.24MB/sec |
| 20 concurrent write sessions | 99.01% | 0.35MB/sec |
4 CPUs, 16GB RAM, 2GB DriverHeapSize, number of threads = 5
| Sessions | CPU Utilization | Throughput |
|---|---|---|
| Single read session | 3.76% | 9.12MB/sec |
| 5 concurrent read sessions | 14.63% | 8.6MB/sec |
| 20 concurrent read sessions | 29.69% | 8.83MB/sec |
| Sessions | CPU Utilization | Throughput |
|---|---|---|
| Single write session | 5.52% | 3.37MB/sec |
| 5 concurrent write sessions | 50.46% | 2.94MB/sec |
| 20 concurrent write sessions | 97.71% | 0.66MB/sec |