Performance Tuning

elavenil · Post by **elavenil** » Wed Feb 22, 2006 6:17 am

Hi,

We have completed the development in Windows server and we are in the process of setting up production server in UNIX. And the project has been migrated into production server and the job is running very slow compare to development server while running a job to do the quality check of the server.

Development server has 2 CPUs while production server has single CPU. Ohter than increasing no of CPUs, Is there any parameter to be changed in UVConfig to improve the performance?

Can you please enlighten me some light in the above.

Regards
Elavenil

ArndW · Post by **ArndW** » Wed Feb 22, 2006 6:29 am

Elavenil,

there are very many factors that affect performance; it is impossible to give a good answer to your question. You need to find out which part is making the performance decrease - it could be CPU, but it could just as well be connections to the database or factors which might seem completely unrelated at first.

The most obvious difference is in CPUs. If you measure your system while the job is running does your CPU utilization go up and hover over 90%?

ray.wurlod · Post by **ray.wurlod** » Wed Feb 22, 2006 4:02 pm

Start by defining "performance" and how you measure it. Rows/second is not a valid mechanism for comparing between jobs for a number of reasons.

elavenil · Post by **elavenil** » Wed Feb 22, 2006 9:37 pm

Thanks for your responses. I will try measuring/analysing the performance factors as you guys suggessted.

Regards
Elavenil