performance difference of same job on 2 environments

ssunda6 · Post by **ssunda6** » Wed Nov 21, 2007 5:02 am

Hi All,

We have 2 servers with datastage installed on both. A particular job is showing huge difference in performance (time) from one server to the other one. As both servers are different, it might be normal to have difference in job completion time because of properties but for other jobs there is not much difference.

Only for this particular job, on 1st server it is taking 18 minutes and on the 2nd server 8 hours.

The job design is as follows:
Oracle stage -> Change Capture stage (with before data from another oracle table) -> Lookup stage -> transformer -> target oracle table.

Properties like keys, index on tables are same on both servers.
Data from source is around 7 lakhs and from before dataset(table) is 9 lakhs

Please provide some pointers on why there is huge difference in job completion time.

Regards,
ssunda.

ray.wurlod · Post by **ray.wurlod** » Wed Nov 21, 2007 5:10 am

What is different between the two servers? "Nothing" is not the correct answer.

ssunda6 · Post by **ssunda6** » Wed Nov 21, 2007 6:28 am

I dont know the differences between the 2 servers. Whenever we complete development on 1st server, for testing purpose we move to the 2nd server. (The job is taking more time on 1st server).

The problem is that only for this particular job , we have this problem. For remaining jobs, there is no much difference.

Regards,
ssunda.

ogmios · Post by **ogmios** » Wed Nov 21, 2007 7:05 am

Is the data being processed the same on both servers?

ssunda6 · Post by **ssunda6** » Thu Nov 22, 2007 11:29 pm

Yes. The data is same.

ogmios · Post by **ogmios** » Fri Nov 23, 2007 1:00 am

ssunda6 wrote:Yes. The data is same.

If all else is the same, I would have your DBAs import the stats from the one database into the other.