Performance degraded exponentially

rafik2k · Post by **rafik2k** » Thu Apr 26, 2007 7:10 am

Hi,
I am facing one serious performance issue from today in jobs.
AS of day before yesterday things were going fine and processing speed was 316 rows/sec
Yesterday just the server was moved to another place. Nothing has been installed/ reinstalled on the server since then.
Now today i run the same job, processing speed goes down to 2 rows/sec that's strange.

Source and target environment of my job is in the same ds server.

Could you plz share your experince what is reason of this and how to improve perofmance?

Thanks in advance.

kcbland · Post by **kcbland** » Thu Apr 26, 2007 8:21 am

Sounds like the server was restarted after the move. Chances are that something is now running on the server affecting performance. Check if any virus software like Norton is running and interfering.

rafik2k · Post by **rafik2k** » Thu Apr 26, 2007 8:53 am

Yes Server was restarted after the move.

But the performacne in Task Manager showing that CPU usage was less that 10 % and also PF Usage was very less.

nick.bond · Post by **nick.bond** » Thu Apr 26, 2007 8:58 am

Where are all the disks? are they local to the box or is it a SAN?

nick.bond · Post by **nick.bond** » Thu Apr 26, 2007 8:59 am

Maybe it has nothing to do with the move

What is the job doing? is it writing to hashed files? looking up against DB?

rafik2k · Post by **rafik2k** » Thu Apr 26, 2007 9:06 am

One month back disk was SAN. at that time we had good performance

Now all disks are on local server, but since then nothing has been changed.

My job is extracting from db2, have some transformation rule and loading into target db2 table.