Slow performance of the system

I

IvanM

New Member
Hi Experts,
I have a problem and I do not know where exactly it is. Our billing application is running over Progress 9.1D SP06 Database on HP-UX 11. Two days the billing process is painfully slow also the production of bill into a text files.

I do not pretend to be deeply familiar with the Progress database but common monitoring tool such as promon shows Buffer Hits 99%, Writes by APW 100%, Records reads 16 287.6 per second, DB Reads 2 per second, Shared memory is 335 100K , Record locking are nearly 48 the printing in to a text file and also the billing process is performed in parallel into 6 streams.

Did somebody can tell my how to find even one clue or something showing is it database problem (e.g broken index) or it is UNIX hardware or software problem.

Thanks in advance

IvanM

 
Has something changed? It sounds like everything was fine until 2 days ago... I'd start looking at recent changes as the most likely culprit.

Having said that...

It would be helpful to know more about how the system is configured. What are the startup parameter settings for both db server and clients. How is the db laid out on disk, what options such as block sizes, rows per block and bi cluster sizes have been set and so forth. What can you tell us about the system's load? Then you need to dig deeper into the perfomance metrics -- promon is a good start but it is hard to use properly. I suggest that you give ProTop a try:

http://www.greenfieldtech.com/articles/protop.shtml

Performance problems are very complex to analyze. It is unusual to find simple solutions. <Shameless self serving plug -- hire a performance tuning consultant to help!>
 
are your processing hitting the same tables? are your parrellel processes hitting the same tables and causing contention for records? check the lock table when it runs and watch for that table number. Are there lots of exclusive locks that do not get cleared out very fast? or do a couple of locked records hold up a number of other locks? If this is happening those processes can't be run in parrellel.
 
same problem

Hi
I have the same perfromance problem and everything seems ok when I look at the system.
I have two suspects. But do not know the answers. I want your help in the below questions.

1. Progress works in 32 bit (Am I correct? ) But Unix Aix works in 64 bits.
Can this cause performance loss?
2. Because Progress works in 32 bit, as in Oracle maybe it cannot use more than 3 GB memory whatever your memory capacity is. can it?
 
Progress can be either 32 bit or 64 bits. On AIX you need to be at 10.0B or higher for the 64 bit port. (On all platforms where 64 bits are available you have to explicitly order the 64 bit port...)

Typically 32 or 64 is not a direct cause of performance problems. It mostly means that if you have 32 bits you're limited in how much RAM you can use for -B. The 32 bit limit varies due to a number of factors but it is generally a little less than 2GB.

Performance problems are complex. Feel free to hire a competent consultant ;)
 
You must log in or register to reply here.
Back
Top