Migration to different host became speed 10 times lower
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 158
- Joined: Tue Mar 15, 2005 3:16 am
Migration to different host became speed 10 times lower
Hi
We recently migrated our dev project from one linux box "A" to other linux box "B".
There was a job, which creates a hash file from a table as follows.
DB Stage -> Hash File
The number of records in DB : 2,471,947 records
It took 10 mins in our earlier "A" system (at 4510 rows/sec), where as it took 1 hr 40 mins in new "B" system at (at 406 rows/sec).
Both are having the following versions:
DataStage server 7.5.2
Any inputs on this would be great.
Thanks
Sai
We recently migrated our dev project from one linux box "A" to other linux box "B".
There was a job, which creates a hash file from a table as follows.
DB Stage -> Hash File
The number of records in DB : 2,471,947 records
It took 10 mins in our earlier "A" system (at 4510 rows/sec), where as it took 1 hr 40 mins in new "B" system at (at 406 rows/sec).
Both are having the following versions:
DataStage server 7.5.2
Any inputs on this would be great.
Thanks
Sai
-
- Participant
- Posts: 158
- Joined: Tue Mar 15, 2005 3:16 am
A system's top command output as follows
top - 23:34:59 up 54 days, 4:29, 2 users, load average: 0.00, 0.00, 0.00
Tasks: 123 total, 1 running, 122 sleeping, 0 stopped, 0 zombie
Cpu(s): 0.0% us, 0.0% sy, 0.0% ni, 99.9% id, 0.0% wa, 0.0% hi, 0.1% si
Mem: 8166112k total, 8137588k used, 28524k free, 50252k buffers
Swap: 2048276k total, 23880k used, 2024396k free, 7890272k cached
B system's top command ouptut as follows
104 processes: 101 sleeping, 2 running, 1 zombie, 0 stopped
CPU states: cpu user nice system irq softirq iowait idle
total 18.4% 0.0% 2.9% 0.0% 0.0% 7.7% 70.9%
cpu00 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 100.0%
cpu01 0.1% 0.0% 0.0% 0.0% 0.0% 0.0% 99.8%
cpu02 65.0% 0.0% 10.5% 0.0% 0.0% 15.1% 9.1%
cpu03 8.3% 0.0% 1.1% 0.0% 0.0% 15.7% 74.6%
Mem: 5907468k av, 5886096k used, 21372k free, 0k shrd, 521072k buff
2691660k actv, 1740296k in_d, 129928k in_c
Swap: 5907432k av, 0k used, 5907432k free 3382448k cached
Please let me know specifically you need anything about the differences
Thanks
Sai
top - 23:34:59 up 54 days, 4:29, 2 users, load average: 0.00, 0.00, 0.00
Tasks: 123 total, 1 running, 122 sleeping, 0 stopped, 0 zombie
Cpu(s): 0.0% us, 0.0% sy, 0.0% ni, 99.9% id, 0.0% wa, 0.0% hi, 0.1% si
Mem: 8166112k total, 8137588k used, 28524k free, 50252k buffers
Swap: 2048276k total, 23880k used, 2024396k free, 7890272k cached
B system's top command ouptut as follows
104 processes: 101 sleeping, 2 running, 1 zombie, 0 stopped
CPU states: cpu user nice system irq softirq iowait idle
total 18.4% 0.0% 2.9% 0.0% 0.0% 7.7% 70.9%
cpu00 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 100.0%
cpu01 0.1% 0.0% 0.0% 0.0% 0.0% 0.0% 99.8%
cpu02 65.0% 0.0% 10.5% 0.0% 0.0% 15.1% 9.1%
cpu03 8.3% 0.0% 1.1% 0.0% 0.0% 15.7% 74.6%
Mem: 5907468k av, 5886096k used, 21372k free, 0k shrd, 521072k buff
2691660k actv, 1740296k in_d, 129928k in_c
Swap: 5907432k av, 0k used, 5907432k free 3382448k cached
Please let me know specifically you need anything about the differences
Thanks
Sai
-
- Participant
- Posts: 158
- Joined: Tue Mar 15, 2005 3:16 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 158
- Joined: Tue Mar 15, 2005 3:16 am
-
- Premium Member
- Posts: 50
- Joined: Tue Jan 02, 2007 1:40 am
-
- Participant
- Posts: 158
- Joined: Tue Mar 15, 2005 3:16 am