Report output field and column headings

This section identifies the fields or column headings associated with each historical report template.

Note: Fields and column headings in this section that are identified with an asterisk (*) are also the OpenEdge Management-supplied defaults associated with each report type.
AppServer Application Profile

Table 2–2 identifies the AppServer Application Profile column headings.

Table 2–2: AppServer Application Profile column headings 
Run Count*
Average Request Duration (ms)
Maximum Request Duration (ms)
Return Code Success
Return Code Error
Return Code Quit
Return Code Stop
Sample Count

AppServer Performance

Table 2–3, Table 2–4, and Table 2–5 identify the column headings for an AppServer Performance graphical report.

Table 2–3: AppServer Client Activity column headings 
Average Active Clients*
Maximum Active Clients
Client Requests
Average Client Requests
Maximum Client Requests
Sample Count

Table 2–4: AppServer Broker Activity column headings 
Requests Completed
Requests Queued
Requests Queued %
*Average Request Duration (ms)
Maximum Request Duration (ms)
Average CPU Usage %
Maximum CPU Usage %
Average Memory Usage (k)
Maximum Memory Usage (k)
Sample Count

Table 2–5: AppServer Activity column headings 
Average Pool CPU Usage %
Maximum Pool CPU
Usage %
Average Pool Memory Usage % (k)
Maximum Pool Memory Usage (k)
*Average Busy Server Count
Maximum Busy Server Count
Average Busy Server Time (ms)
Average Locked Server Count
Maximum Locked Server Count
Average Locked Server Time (ms)
Sample Count

Database After-imaging

Table 2–6 identifies the column headings for a Database After-Imaging graphical report.

Table 2–6: Database After-Imaging column headings 
ActLog_AIBBufWaits
ActLog_AIByteWrites
ActLog_AINoBufAvail
ActLog_AIPartialWrites
ActLog_AIRecWrites
ActLog_AITotWrites*
ActLog_AIWWrites*

Database Area Status

Table 2–7 identifies the column headings for a Database Area Status graphical report.

Table 2–7: Database Area Status column headings 
Sample Count
Total Blocks
Hi Water Mark*
Free Blocks
RM Blocks
Blocks Available*
Pct. Blocks Available

Database Before-imaging

Table 2–8 identifies the fields for a Database Before-Imaging graphical report.

Table 2–8: Database Before-Imaging fields  
ActLog_BITotReads
ActLog_BITotWrites*
ActLog_BIWWrites*
ActSum_BIReads
ActSum_BIWrites
ActLog_BIBBufWaits
ActLog_BIByteReads
ActLog_BIByteWrites
ActLog_BIEBufWaits
ActLog_BIPartialWrites
ActLog_BIRecReads
ActLog_BIRecWrites

Database Checkpointing

Table 2–9 identifies the column headings for a Database Checkpointing graphical report.

Table 2–9: Database Checkpointing column headings 
Sample Count
Checkpoint Length*
Buffer Scanned
Checkpoint Queue
APW Queue
Buffers Flushed*

Database Details

Table 2–10 identifies the fields for a Database Details graphical report.

Table 2–10: Database Details fields
ActBuf_Flushed
ActBuf_LogicReads*
ActBuf_LogicWrites*
ActSum_DbReads
ActSum_DbWrites
ActRec_RecRead
ActLog_BITotWrites
ActLog_BIWWrites
ActAPW_APWEnq
ActIOType_IdxReads
ActIOType_IdxWrites
ActAPW_APWQWrites
ActAPW_BufsCkpt
ActAPW_BufsScanned
ActAPW_CkptQWrites
ActAPW_Ckpts
ActAPW_DBWrites
ActAPW_Marked
ActAPW_ScanCycles
ActAPW_ScanWrites
ActAPW_TotDBWrites
ActBuf_Deferred
ActBuf_OSReads
ActBuf_OSWrites
ActIdx_Create
ActIdx_Delete
ActIdx_Find
ActIdx_Free
ActIdx_Remove
ActIdx_Splits
ActLock_CancelReq
ActLock_Downgrade
ActLock_ExclFind
ActLock_ExclLock
ActLock_ExclReq
ActLock_ExclWait
ActLock_RecGetLock
ActLock_RecGetReq
ActLock_RecGetWait
ActLock_ShrFind
ActLock_ShrLock
ActLock_ShrReq
ActLock_ShrWait
ActLock_UpgLock
ActLock_UpgReq
ActLock_UpgWait
ActRec_ByteCreate
ActRec_ByteDel
ActRec_ByteRead
ActRec_ByteUpd
ActRec_FragCreate
ActRec_FragDel
ActRec_FragRead
ActRec_FragUpd
ActRec_RecCreate
ActRec_RecDel
ActRec_RecLock
ActRec_RecUpd
ActRec_RecWait
ActSum_AllocNewRm
ActSum_BytesAlloc
ActSum_Examined
ActSum_FromFree
ActSum_FromRm
ActSum_Removed
ActSum_RetFree
ActSum_TakeFree
ActSum_AiWrites
ActSum_BiReads
ActSum_Commits
ActSum_DBAccesses
ActSum_DbExtend
ActSum_Undos
ActLog_AIBBufWaits
ActLog_AIByteWrites
ActLog_AINoBufAvail
ActLog_AiPartialWrites
ActLog_AIRecWrites
ActLog_AITotWrites
ActLog_AIWWrites
ActLog_BIBufWaits
ActLog_BIByteReads
ActLog_BIByteWrites
ActLog_BIEBufWaits
ActLog_BIPartialWrites
ActLog_BIRecReads
ActLog_BIRecWrites
ActLog_BITotReads
ActIOType_AiReads
ActIOType_AiWrites
ActIOType_BiReads
ActIOType_BiWrites
ActIOType_DataReads
ActIOType_DataWrites

Database Disk Information

Table 2–11 identifies the fields for a Database Disk Information graphical report.

Table 2–11: Database Disk Information fields  
ActSum_DbReads
ActSum_DbWrites
ActAPW_DBWrites*
ActAPW_TotDBWrites*
ActSum_DbAccesses
ActSum_DbExtend
ActIOType_AiReads
ActIOType_AiWrites
ActIOType_BiReads
ActIOType_BiWrites
ActIOType_DataReads
ActIOType_DataWrites
ActIOType_IdxReads
ActIOType_IdxWrites

Database Index Analysis

Table 2–12 identifies the column headings for a Database Index Analysis graphical report.

Table 2–12: Database Index Analysis column headings  
Sample Count
Max Block Count
Min Block Count
Avg Block Count
Max Byte Count
Min Byte Count
Avg Byte Count
Max Util Percent
Min Util Percent
Avg Util Percent*
Max Level Count
Min Level Count
Avg Level Count

Database Index Usage

Table 2–13 identifies the column headings for a Database Index Usage graphical report.

Table 2–13: Database Index Utilization column headings  
Index Reads*
Index Splits
Index Creates
Index Deletes

Database Locking

Table 2–14 identifies the fields for a Database Locking graphical report.

Table 2–14: Database Locking fields  
ActLock_CancelReq
ActLock_Downgrade
ActLock_ExclFind
ActLock_ExclLock
ActLock_ExclReq
ActLock_ExclWait*
ActLock_RecGetLock
ActLock_RecGetReq
ActLock_RecGetWait*
ActLock_ShrFind
ActLock_ShrLock
ActLock_ShrReq
ActLock_ShrWait*
ActLock_UpgLock
ActLock_UpgReq
ActLock_UpgWait*

Database Buffer I/O

Table 2–15 identifies the fields for a Database Buffer I/O graphical report.

Table 2–15: Database Memory Usage fields  
ActBuf_Flushed
ActBuf_LogicReads*
ActBuf_LogicWrites
ActBuf_Deferred
ActBuf_OSReads*
ActLog_AIBBufWaits
ActLog_AINoBufAvail
ActLog_AIPartialWrites
ActLog_BIBBufWaits
ActLog_BIEBPartialWaits
ActLog_BIPartialWrites

Database Record Information

Table 2–16 identifies the fields for a Database Record Information graphical report.

Table 2–16: Database Record Information fields 
ActRec_RecRead
ActRec_RecCreate*
ActRec_RecDel*
ActRec_ByteRead
ActRec_ByteUpd
ActRec_FragCreate
ActRec_FragDel
ActRec_FragRead
ActRec_FragUpd
ActRec_RecCreate
ActRec_RecDel
ActRec_RecLock*
ActRec_RecUpd*
ActRec_RecWait
ActRec_ByteCreate
ActRec_ByteDel

Database Server Activity

Table 2–17 identifies the column headings for a Database Server Activity graphical report.

Table 2–17: Database Server Activity column headings 
Messages Received
Messages Sent
Bytes Received
Bytes Sent
Records Received*
Records Sent*
Min Users
Max Users
Avg Users

Database Summary

Table 2–18 identifies the fields for a Database Summary graphical report.

Table 2–18: Database Summary fields 
ActBuf_Flushed
ActBuf_LogicReads*
ActBuf_LogicWrites*
ActSum_DbReads
ActSum_DbWrites
ActRec_RecRead
ActLog_BITotWrites
ActLog_BIWWrites
ActAPW_BufsCkpt
ActBuf_OSReads
ActBuf_OSWrites
ActIdx_Create
ActIdx_Delete
ActIdx_Find
ActIdx_Free
AdxIdx_Remove
ActIdx_Splits
ActSum_Commits
ActSum_DbAccesses*
ActSum_DbExtend
ActIOType_DataReads
ActIOType_IdxReads
ActIOType_IdxWrites

Database Table Analysis

Table 2–19 identifies the column headings for a Database Table Analysis graphical report.

Table 2–19: Database Table Analysis column headings 
Sample Count
Max Record Count
Min Record Count
Ave Record Count*
Max # of Bytes
Min # of Bytes
Ave # of Bytes
Max # of Fragments
Min # of Fragments
Ave # of Fragments
Max Scatter Factor
Min Scatter Factor
Ave Scatter Factor

Database Table Usage

Table 2–20 identifies the column headings for a Database Table Usage graphical report.

Table 2–20: Database Table Usage column headings
Record Reads*
Record Updates*
Record Creates*
Record Deletes*

CPU Summary

Table 2–21 identifies the fields for a CPU Summary graphical report.

Table 2–21: CPU Summary fields
CPU_User*
CPU_System*
CPU_Wait*
CPU_Idle

File Summary

Table 2–22 identifies the column headings for a File Summary graphical report.

Table 2–22: File Summary column headings
Sample Count
Average File Size (k)*
Minimum Size (k)
Maximum Size (k)

Network Activity

Table 2–23 identifies the column headings for a Network Activity graphical report.

Table 2–23: Network Activity column headings
Sample Count
Avg. Response*

System Disk Device Activity

Table 2–24 identifies the column headings for a System Disk Device Activity graphical report.

Table 2–24: System Disk Device Activity column headings
Sample Count
Pct Busy*
Avg Queue
Avg Wait
Avg Serve
Minimum Busy
Maximum Busy

System Filesystem Usage

Table 2–25 identifies the column headings for a System Filesystem Usage graphical report.

Table 2–25: System Filesystem Usage column headings
Sample Count
Capacity
Pct Used*
Current Available
Maximum Available
Minimum Available

System Memory Summary

Table 2–26 identifies the column headings for a System Memory Summary graphical report.

Table 2–26: System Memory Summary column headings
Max System Memory
Min System Memory
Max Virtual Memory
Min Virtual Memory
Max Free System Memory
Min Free System Memory
Max Free Virtual Memory
Min Free Virtual Memory
Pages In
Pages Out

WebSpeed Application Profile

Table 2–27 identifies the column headings for a WebSpeed Application Profile graphical report.

Table 2–27: WebSpeed Application Profile column headings 
Run Count*
Average Request Duration (ms)
Maximum Request Duration (ms)
Sample Count

WebSpeed Performance

Table 2–28, Table 2–29, and Table 2–30 identify the column headings for a WebSpeed Performance graphical report.

Table 2–28: WebSpeed Client Activity column headings 
Average Active Clients*
Maximum Active Clients
Client Requests
Average Client Requests
Maximum Client Requests
Sample Count

Table 2–29: WebSpeed Broker Activity column headings 
Requests Completed
Requests Queued
Requests Queued %
*Average Request Duration (ms)
Maximum Request Duration (ms)
Average CPU Usage %
Maximum CPU Usage %
Average Memory Usage (k)
Maximum Memory Usage (k)
Sample Count

Table 2–30: WebSpeed Server Activity column headings 
Average Pool CPU Usage %
Maximum Pool CPU Usage %
Average Pool Memory Usage (k)
Maximum Pool Memory Usage (k)
*Average Busy Server Count
Maximum Busy Server Count
Average Busy Server Time (ms)
Average Locked Server Count
Maximum Locked Server Count
Average Locked Server Time(ms)
Sample Count


Copyright © 2008 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095