Try OpenEdge Now
skip to main content
Database Administration
Reference : PROMON Utility : R&D Other Displays : Performance Indicators
 
Performance Indicators
Displays activity statistics related to performance.

PROMON Performance Indicators display

The following shows a sample Performance Indicators display.
09/19/03         Activity: Performance Indicators
17:04:35         from 09/15/03 10:01 to 09/19/03 13:26 (99 hrs 24 min)

                               Total      Per Min    Per Sec    Per Tx
Commits                        0          0          0.00       0.00
Undos                          0          0          0.00       0.00
Index Operations               0          0          0.00       0.00
Record Operations              3          18         0.30       0.00
Total o/s i/o                  28         0          0.00       0.00
Total o/s reads                23         0          0.00       0.00
Total o/s writes               5          0          0.00       0.00
Background o/s writes          5          0          0.00       0.00
Partial log writes             1          0          0.00       0.00
Database extends               0          0          0.00       0.00
Total waits                    0          0          0.00       0.00
Lock waits                     0          0          0.00       0.00
Resource waits                 0          0          0.00       0.00
Latch timeouts                 0          0          0.00       0.00
buffer pool hit rate: 68%
The Performance Indicators display shows the total number of each type of operation for the sample period (Total), the number of operations per minute (Per Min) the number of operations per second (Per Sec), and the number of operations per transaction (Per Tx). The display shows the following operations:
*Commits — The number of committed transactions.
*Undos — The number of transactions that were rolled back.
*Index Operations — The total of all operations performed on indexes (for example, index additions and deletions).
*Record Operations — The total of all operations on records (for example, record additions and deletions).
*Total o/s i/o — The total number of read and write operations performed.
*Total o/s reads — The total number of read operations performed.
*Total o/s writes — The total number of write operations performed.
*Background o/s writes — The total number of writes performed by background writers (APWs, BIW, and AIW). See Managing Performance for more information on background writers.
*Partial log writes — Writes to the BI file made before the BI buffer is full. This might happen if:
*The Delayed BI File Write (-Mf) parameter timer expired before the buffer was filled.
*An APW attempts to write a block whose changes are recorded in a BI buffer that has not been written. Because BI notes must be flushed before the AI note is flushed, the AIW writes the data in the BI buffer before the buffer is full so it can do the AI write.
*An AIW ran ahead of the BIW. Because BI notes must be flushed before the AI notes can be written, the AIW writes the BI buffer before it is full, so it can do the AI write.
*Database extends — The total number of times the database was made larger by allocating operating system blocks.
*Total waits — The total number of waits.
*Lock waits — The number of times the database engine waited for a lock to be released.
*Resource waits — The number of times the database engine waited for a resource, such as a row lock, a buffered lock in shared memory, or a transaction end lock, to become available.
*Latch timeouts — The number of times a spin lock expired, causing the process to nap, when attempting to acquire a latch.
*Buffer pool hit rate — The percentage of times that the database engine found a record in the buffer pool and did not have to read the record from disk.