Kbase P153915: _mprosrv process taking 20 - 30% of CPU periodically
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
04/10/2010 |
|
Status: Verified
SYMPTOM(s):
_mprosrv process taking 20 - 30% of CPU periodically
promon gather script showing napping/contention on the LRU (Least Recently Used) latch.
FACT(s) (Environment):
No errors are occurring
Added additional memory and issue persists
Database being started with -spin parameter
Multiple CPUs installed on this machine.
Issue seemed to diminish when additional CPUs were added to the machine.
-semsets parameter is being used.
Sun Solaris SPARC 64-bit
OpenEdge 10.1C
CAUSE:
There is contention on the Buffer pool LRU (Least Recently Used) chain latch. This latch is used when the Buffer pool becomes full. Buffers are placed on the buffer pool least recently used chain. The buffer pool LRU chain latch is used when the engine needs to identify a buffer that can be evicted for the purpose of reading a new block into memory.
FIX:
Increase the Database Buffer Pool so that more blocks can be accommodated in shared memory. Additional investigation may need to be done in an effort to identify processes that may be monopolizing the buffer pool. In those situations making use of private buffers may also be warranted.