Performance issue with Hashfiles
Posted: Wed Sep 17, 2008 6:54 pm
Hi,
I migrated the project from 7.5 version on HP Unix machine ( 2-CPU) to version 8.0.1 on AIX machine(1 cpu) and moved all the files to the new server. I didnt copy the hashfiles from old server to new server. what i did was i ran all the jobs where the hashfiles are created in the project directory of new server.
when i try to run the remaining jobs, the perfromance is very slow when compare to old server. For example some jobs in 7.5 version ends in 50mins and its taking more than 3 hrs to run in version 8. Even the number of rows per sec in 7.5 is 60 where as in version 8 is 5rows/sec .
I checked the cpu utilization and its almost 90 to 95% untilized. Is this is due to Number of CPUS? how can i increase the performance of the jobs(number of rows from hash file to transformer) ?? .
Any inputs would be really appreciated.
Thanks in Advance
I migrated the project from 7.5 version on HP Unix machine ( 2-CPU) to version 8.0.1 on AIX machine(1 cpu) and moved all the files to the new server. I didnt copy the hashfiles from old server to new server. what i did was i ran all the jobs where the hashfiles are created in the project directory of new server.
when i try to run the remaining jobs, the perfromance is very slow when compare to old server. For example some jobs in 7.5 version ends in 50mins and its taking more than 3 hrs to run in version 8. Even the number of rows per sec in 7.5 is 60 where as in version 8 is 5rows/sec .
I checked the cpu utilization and its almost 90 to 95% untilized. Is this is due to Number of CPUS? how can i increase the performance of the jobs(number of rows from hash file to transformer) ?? .
Any inputs would be really appreciated.
Thanks in Advance