Does anyone know of a profiling tool to help optimize a DataStage job and find where the performance bottlenecks are?
Thanks,
Anthony
DataStage profiler?
I am fairly confident there isnt any.
Two reasons. One is that so few people actually understand exactly what DataStage jobs are doing. The other is that the "bottleneck" can rarely be sheeted home to DataStage - almost always in my experience the bottleneck has been outside, perhaps running out of CPU (monitor idle time on the CPUs), memory (monitor paging activity), disk (be aware of data delivery rates), network (what bandwidth can you REALLY get, are you using packets efficiently, with what other traffic are you competing, etc) or database servers.
-----Original Message-----
From: akerschen@harland.net [mailto:akerschen@harland.net]
Sent: Friday, 21 September 2001 08:11
To: datastage-users@oliver.com
Subject: DataStage profiler?
Does anyone know of a profiling tool to help optimize a DataStage job and find where the performance bottlenecks are?
Thanks,
Anthony
Two reasons. One is that so few people actually understand exactly what DataStage jobs are doing. The other is that the "bottleneck" can rarely be sheeted home to DataStage - almost always in my experience the bottleneck has been outside, perhaps running out of CPU (monitor idle time on the CPUs), memory (monitor paging activity), disk (be aware of data delivery rates), network (what bandwidth can you REALLY get, are you using packets efficiently, with what other traffic are you competing, etc) or database servers.
-----Original Message-----
From: akerschen@harland.net [mailto:akerschen@harland.net]
Sent: Friday, 21 September 2001 08:11
To: datastage-users@oliver.com
Subject: DataStage profiler?
Does anyone know of a profiling tool to help optimize a DataStage job and find where the performance bottlenecks are?
Thanks,
Anthony