Progress 9.1D run on HPUX 11.1 v3

T

Terence Chu

New Member
We had migrated our Progress 9.1d to a new HP unix server. Because of 11.1 v1 not available on new server, we purchase a new server with OS 11.1 v3.

After we migrated to new server, database performance become very slow (most of time). Does anyone know any fine tuning of configuration to improve the performance?

If there is no solution next week, we needed to rollback to old server.:(Thank you all.
 
Yes. We needed to stay on 9.1D. Because many application stick on it and need many effort to update it.
Do you have any suggestion? Now our database very very slow when more user login........:(
 
I can't help you with tuning old Progress on new HP-UX. But you would be better off if you could move your application to a new version of Progress, like 10.2B07 or 11.2.1. If you have source code for your application and a development license, you should be able to do it.
 
Did you also change the storage subsystem? If, for instance, you went from RAID10 to RAID5 that would explain decreased performance...

Does the new server have the same amount of RAM? Same number of CPUs?

How did you move the databases & app? Are the tunable parameters and options the same from old to new? Or did you maybe forget to set some? Or maybe nobody knows because it was last done 10 years ago?
 
what performance data have you collected on the OS and database ?
Do you have glance on the server ? What stats does it show ?
Do you know how to use promon to collect stats on the database ?
 
Thanks All~

Seems the problem has been fixed.

Previously we use a single-core CPU server and haven't configure the "-spin" in the .pf file. After we migrated to a quad-core CPU server, the performance drop suddenly when more user logins.

We put "-spin 24000" to the pf file and database seems running smooth now:)

Prgress knowledgebase : P136018
 
You must log in or register to reply here.
Back
Top