Buffer hits 0%

J

jigar.darji

New Member
The performance of my production environment deteriorates on many ocassions such as now.

I checked promon activity option for my databses and found buffer hits to be 0% and 1%

Also the db files contain this recurring error
06:04:59 SRV 44: Error writing msg, socket=478 errno=32 usernum=1284 disconnected. (796)

Can anyone help please.
 
What version of Progress are you running and what platform are you running it on? (It is clear from the .lg file excerpt that it is no greater than v9 -- but the gory details matter...)

Also -- you'll save us all a lot of time and frustration if you describe the system, it's usage, startup parameters (both db server and client parameters), configuration options and system load as best you can.

Or you could just hire a consultant to swoop in and fix it ;)
 
Hi Tom,

here is a more detailed picture

Progress 9.1E running on Linux i686 i686 i386 GNU/Linux

Production db around 140 GB, peak users around 600-700

startup params for qaddb

-B 250000 -L 163840 -spin 80000 -bibufs 80 -aibufs 80 -n 1100 -c 350 -S mfgusprod-svr -N TCP -Mn 205 -Mpb 200 -Ma 5 -Mi 1 -ServerType 4GL -tablerangesize 716 indexrangesize 1730 -minport 10000 -maxport 20000 -biblocksize 16000 aiblocksize 16000 -semsets 22

client params

-c 30 -d mdy -yy 1920 -Bt 350 -D 100 -l 500 -mmax 10240 -nb 200 -s 63 -rereadnolock -noshvarfix -h 12 -TB 31 -TM 32

system load hovers around 30 which peaks to 100 occasionally
 
PROMON has many bugs. In v9 there is a bug regarding the calculation of hit% when the db has been running for a while.

On the bright side this generally only happens when you look at the "since db start" numbers and those are pretty much useless anyway. It is generally much more helpful to look at an activity sample (use the "s" command) which avoids the problem.

You can also use ProTop instead of PROMON. (There is a character version on the website too.)

Judging from those parameter settings you'd also probably do well to engage a quality db performance consultant to look at your system ;)
 
You must log in or register to reply here.
Back
Top