Chris Hughes
ProgressTalk.com Sponsor
Hi All
I'd appreciate your opinions please on something I don't feel is quite right......
We have a back office logistics system running on Progress with approx 80 users / system users using it at peak. We are experiencing lots of contention with locking which has lead me to check out promon. My stats for over 554 hours are
Things that I think may concern me
Locks to DB writes ratio - 1%
Why do I have more commits than writes?
I'm not expecting any answers on how to fix this, I just wonder whether there is any justification for writing an application this way!
Thanks in advance.
Chris.
I'd appreciate your opinions please on something I don't feel is quite right......
We have a back office logistics system running on Progress with approx 80 users / system users using it at peak. We are experiencing lots of contention with locking which has lead me to check out promon. My stats for over 554 hours are
Code:
Commits 31794654 16.0 Undos 322 0.0
Record Updates 641856 0.3 Record Reads 6837760789 3440.8
Record Creates 553839 0.3 Record Deletes 300993 0.2
DB Writes 1315292 0.7 DB Reads 5490877 2.8
BI Writes 183905 0.1 BI Reads 94692 0.0
AI Writes 0 0.0
Record Locks 144061838 72.5 Record Waits 54 0.0
Checkpoints 80 0.0 Buffs Flushed 546 0.0
Things that I think may concern me
Locks to DB writes ratio - 1%
Why do I have more commits than writes?
I'm not expecting any answers on how to fix this, I just wonder whether there is any justification for writing an application this way!
Thanks in advance.
Chris.