Performance Issue - HP UX 11 with Progress 9.1D

[Raghuram KG]

Hi All,

We are on MFG/PRO Version eb2 SP3(ERP) running on Progress 9.1D and HP UX 11. There are roughly about 100 odd concurrent users at any given point of time accessing the application.

We are facing quite a bit of performance issues.

I request for a help in the area of performance tuning required on HP BOX either at OS level or at Progress RDBMS level, or it could be a combination of both.

Any suggestion/tip in this regard will be of great help.

Regards,
Raghu

[Steve Steel]

Hi


For memory issues and good tools

Memory Usage (â What is using all of the memoryâ ?)

by:eric.herberholz@hp.com

Last modified: March 23, 2004

Latest version also available at external ftp site:

ftp://eh:spear9@hprc.external.hp.com/memory.htm



For kernel tuning there is so much

What issue do you have . Have you tried glance

http://docs.hp.com/hpux/onlinedocs/TKP-90202/TKP-90202.html

Steve Stee

[Julio Yamawaki]

Hi,

For Progress DB, there are some issues to look for in case of poor performance:
1. Is there memory enough in UNIX box?
2. Do you have a high CPU usage?
3. Do you have a high disk rate?
4. Do you have programs made yours? Are these programs performing well? A bad program can put all DB in a bad performance
5. To monitor the database, use promon -> in this case, try to check the buffer hits in more then 75% in write and 85% em read (notice that, if you use only online tasks, this can be 85/95%)
6. What is the size of the databases, have you eve done a dump/load of theses databases?
7. Check index fragmentation using proutil with IXANALYS parameter, check for %Util > 85%, if less, try reindexing and compressing this index
8. Finally, how many disk drivers do you have? Are the .db files and .bi in the same driver? Try putting .db and .bi in separate disks.

Good luck.

[F.A. de Boer]

Hi,

Here are some links regarding Progress Performance. Althoug not quite up to date they have put me in the right direction in the past.

http://www.fast4gl.com/downloads/pperform.html

http://www.westnet.com/~gsmith/progress.html

http://www.peg.com/techpapers/monographs/tuning/tuning.html

Good luck!

Frank