How many _mprosrv.exe processes is too many?

auroraphillip

New Member
My Progress server is having performance issues and hangs occasionally. The logs are not helpful and the only way to recover is a reboot. Most of my Windows Servers have 65 to 70 Processes. My Progress Server regularly has over 270. Any ideas would be appreciated.

Windows 2003 Enterprise Edition
16 GB RAM
16 GB Page File
4 XEON Hyperthreaded Processors

200 _mprosrv.exe Processes

13 Progress Databases

Startup Parameters for the databases:
-B 400000
-L 900000
-bibufs 30
-spin 1000
-S 8200
-Mpb 25
-n 125
-l 50000
-Mn 36
 

Casper

ProgressTalk.com Moderator
Staff member
Hi,

With 13 databases on a windows server I can understand you have performance issues :).
But anyway, you forgot to tell how big the databases are, how busy they are. Is this a memory issue or an IO issue? What does promon tell you? How many disks do you have and how big? Does each database reside on its own disk? Did you move BI and AI to seperate disk? Does your shared memory get swapped? What other parameters do you use?
How do your clients connect to the databases?
Blocksize?

As you can see, too may questions still to give you an answer. You say you are having performance issues. How do you measure performance? What other apps are running on your machine?

What version/patch level of Progress?

-B 400000 with 4K blocksize makes a pretty big shared memory per database, since you have 13 databases (~20 GB)....

Regards,

Casper.
 
Top