Try OpenEdge Now
skip to main content
Database Administration
Maintaining and Monitoring Your Database : Managing Performance : Server performance factors : Database I/O : Monitoring APWs
 
Monitoring APWs
The PROMON R&D option Page Writers Activity display shows statistics about APWs running on your system. The following figure shows a sample display.
01/25/00      Activity: Page Writers
16:29         from 01/25/00 13:56 to 01/26/00 11:23 (21 hrs 27 min)

                             Total   Per Min   Per Sec     Per Tx
Total DB writes              3       0         0.00        0.00
APW DB writes                0       0         0.00        0.00
    scan writes              0       0         0.00        0.00
    APW queue writes         0       0         0.00        0.00
    ckp queue writes         0       0         0.00        0.00
    scan cycles              0       0         0.00        0.00
    buffers scanned          0       0         0.00        0.00
    bfs checkpointed         173     0         0.11        0.14
Checkpoints                  82110   0         5.22        6.79
Marked at checkpoint         0       0         0.00        0.00
Flushed at checkpoint        0       0         0.00        0.00

Number of APWs:                           1
Note: Nonzero numbers in the Flushed at Checkpoint row indicates that the APW was unable to write buffers fast enough to prevent a memory flush. Increase the number of APWs and/or increase the cluster size to eliminate the flush.