Kbase P172147: The _mprosrv processes are using up more CPU than normal.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
07/09/2010 |
|
Status: Unverified
SYMPTOM(s):
The _mprosrv processes are using up more CPU than normal.
The total CPU usage is 95% where it normally is at 30-40%
Code of nightly batch job was modified
Started getting "increase -L messages" in the database log file.
Increased the -L to 48000000
FACT(s) (Environment):
IBM AIX
PowerPC 64-bit
OpenEdge 10.2A
CHANGE:
The Lock table was increased to 48000000 to accommodate the locking issue created by recent code modifications.
CAUSE:
The lock table has no index and needs to scan the entire table for lock information
FIX:
Possible work arounds:
1. Look for the high water mark for the lock table in promon and reduce the -L to around that figure:
promon dbname/#6 "Shared Resources"/"Locking table high water mark"
2. Incorporate the piece of code in solution, P52812 "Poor performance when reading the _Lock table"
or,
3. Look at the modifications done to the code recently as to possible reasons for the increased locking and improve the code where possible.