Teradata Performance Issue.
Posted: Thu Dec 01, 2005 3:29 pm
Hi,
We are using Ascential DS 7.5.1A with the following patches applied:
75003,
80895,
80559,
80036,
76017,
20959
Occassionally the teradata enterprise stage (about 20% of the time), will have a major performance issue. The stage will suddenly process at 4000 rows/second for a job instead of 250,000 rows/second. When the stage does this it will run horrible for the entire job or until it is killed and restarted. What could cause this? The workload on the Ascential server is 10% and on Teradata it is about 20%. Does anyone know a workaround? The difference in job performance is about 1 hour vs. 6.25 hours.
Ascential has been working on this issue for weeks. The have been able to reproduce, but they don't know what is broken or how to fix it.
We are using Ascential DS 7.5.1A with the following patches applied:
75003,
80895,
80559,
80036,
76017,
20959
Occassionally the teradata enterprise stage (about 20% of the time), will have a major performance issue. The stage will suddenly process at 4000 rows/second for a job instead of 250,000 rows/second. When the stage does this it will run horrible for the entire job or until it is killed and restarted. What could cause this? The workload on the Ascential server is 10% and on Teradata it is about 20%. Does anyone know a workaround? The difference in job performance is about 1 hour vs. 6.25 hours.
Ascential has been working on this issue for weeks. The have been able to reproduce, but they don't know what is broken or how to fix it.