Kbase P56718: What indicates the I/O Operations by Process in Promon ?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/2/2011 |
|
Status: Unverified
GOAL:
What indicates the I/O Operations by Process in Promon ?
GOAL:
What does it mean in Promon "I/O operations by process" when it shows large number of BI and AI writes
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
FIX:
Promon "I/O operations by process" can be found from the PROMON menu: R&D, 3.Other displays, 2. I/O Operations by Process.
These I/O operations are made within the BUFFER POOL.
The value is updated in many different places in the Progress C-code itself which mostly deal with Block Access and waiting as follows.
All the following actions will increment the shown value:
- update a block
- check if we have a lock on a block
- get a lock on a block
- wait on a block
- re-read a block
- commit a block
- upgrade a lock on a block
If we are spinning on a block lock then we could increment this counter as well.
A large value on writes for BI and AI usually only indicates a database that has high transaction activity.