Dashboard Data Collector

"Dashboard" Data Collector


For a detailed discussion of these metrics, see ProTop Real-Time - Dashboard View (d) and ProTop Trends - Configuration Dashboard.

To set up an alert on a metric listed here, make note of the Data Collector name at the top of this page, the Alertable Metric and Data Type from the table below and visit Alert Configuration.

Alertable Metric ProTop RT Label Data Type Description
tt_Dashboard     (temptable name)
ai_Busy   num AI extent number of the busy AI extent
aiBusyWt Busy Waits: AI num Number of times a process had to wait because a buffer was held
ai_Curr Curr AI Ext char AI extent number of the currently busy AI extent
ai_Empty Empty AI num Number of AI extents empty and available
aiEmptyWt Empty Wts: AI num Number of times a process waited for an empty BI / AI buffer. Should always be zero
ai_Exts   num Number of AI extents
ai_Full Full AI num Number of Full AI extents
ai_Locked Locked AI num Number of Locked AI extents
aiNotes Notes:AI num Number of notes written to the AI log
aiPartWrt Partial Wr: AI num BI / AI blocks written, not because they are full but because they have been in memory over n seconds (default 3)
ai_Seq Curr Seq# num Current AI sequence number
AIStat   char Is After Imaging enabled?
aiWrts Wrts to Log: AI num Number of notes written to the AI file
aiwWrtPct BIW/AIW Wrt%: AI num Percentage of AI notes written by AIW
aiwWrts BIW/AIW Wrts: AI num Number of notes written to the AI file by the AIW
apwBufsScan Bufs Scanned num Number of database buffers scanned
apwChkPtWrts Chkpt Q Wrts num Checkpoint queue writes
apwQueWrts APW Q Wrts num APW queue writes
apwScanCycles   num Number of APW Scan Cycles
apwScanWrts APW Scan Wrs num Number of scanned database buffers written
apwWrtPct APW Write% num Percentage of database buffer block writes performed by APW
apwWrts APW Writes num Number of APW writes
avgChkPtLen ChkPt Len num Average length of a checkpoint since start of ProTop
avgChkPtStr   char String version of Avg ChkPt Len
biBusyWt Busy Waits: BI num The number of times a process had to wait for someone else to finish before being able to write to a BI file
biEmptyWt Empty Wts: BI num The number of times a process had to wait because all buffers were full
biNotes Notes: BI num Number of notes written to the BI log / AI log
biPartWrt Partial Wr: BI num BI / AI blocks written, not because they are full but because they have been in memory over n seconds (default 3)
biUsed BI MB Used num Megabytes of BI file in use by BI clusters
biWrts Wrts to Log: BI num Number of notes written to the BI/AI file
biwWrtPct BIW/AIW Wrt%: BI num Percentage of BI notes written by BIW
biwWrts BIW/AIW Wrts: BI num Number of notes written to the BI file
BkUpAge Backup Age char Elapsed time since the last full backup using probkup. Third-party backups, OS backups, and incremental backups are not tracked
bogoMipPct   num  
bogoMips BogoMIPS num BogoMIPS measures the single-threaded performance of a 4GL client
bufsFlushed Flushed Bufs num Number of database buffers flushed to disk at the end of the most recent checkpoint
chkPts   num  
con_4gl 4gl Clients num Number of connected 4GL clients
con_4glServ 4gl Servers num Number of 4GL Server processes
con_aimd AI Mgmt num AI Management Daemon
con_AIW BIW/AIW/WDOG: AIW num Values of 0 or 1 indicate the existence [1] or not [0] of the BI writer process, AI writer process and Watchdog process
con_APSV App Server num Number of Application Server connections
con_APW APWs num Number of Asynchronous Page Writers
con_Batch Batch num Number of batch processes
con_BIW BIW/AIW/WDOG: BIW num Values of 0 or 1 indicate the existence [1] or not [0] of the BI writer process, AI writer process and Watchdog process
con_BlkOther Other Blkd num Number of users blocked for any reason other than waiting for a record (ex.: latch)
con_Block   num Total number of blocked users
con_BlockRec Blocked Rec num Number of users blocked waiting for a record
con_Brok Brokers num Number of Broker processes
Con_Helper   num Total number of helper processes connected to the database
Con_Other   num  
con_Remc 4gl RemCnx num Number of remote client / server connections
con_rpla RPLA/RPLS: RPLA num Number of OpenEdge Replication Agents (possible values are 0, 1 or 2)
con_rpls RPLA/RPLS: RPLS num Number of OpenEdge Replication Servers (0 or 1)
con_Self Local num Number of connections using shared memory
con_SQL SQL Clients num Number of SQL client processes
con_SQLServ SQL Servers num Number of SQL Server processes
con_Total Connections num Number of connections to the database
con_TRX TRX num Number of open transactions
con_Util Utilities num Number of database utilities, such as promon or proutil running
con_WDOG BIW/AIW/WDOG: WDOG num Values of 0 or 1 indicate the existence [1] or not [0] of the BI writer process, AI writer process and Watchdog process
con_wta Web Speed num Number of WebSpeed agents connected
currBI Curr BIClstr num Current BI cluser in use
currLks Curr # Locks num Current number of database locks
dashNpct -n % num Number of connections to the database as a percentage of maximum number of connections as set during database server startup (-n)
dbBkUpAge Backup Age char String version of the elapsed time since the last full backup using probkup including days i.e. 10d 15:08. Will contain "Never!" if a backup has not occured. Third-party backups, OS backups, and incremental backups are not tracked.
dbBkUpFull (not visible) num Elapsed time in seconds since the last full backup using probkup. Third-party backups, OS backups, and incremental backups are not tracked
dbBkUpHour   num The current hour if a backup is running, -1 if no backup is running
dbState   char Current state of the database (1=open, 2=not modified since last open, 4=being recovered, 8=being restored, 2048=index repair underway)
dbUpTime DB UpTime char Length of time since the database server process started
EvictBufs Evicted num Number of blocks evicted from the RM chain
HR Hit% num Percentage of database reads read from the database buffer cache
HRstr   char String version of Hit%
idxBlkSplit Idx Blk Spl num Number of index block splits
idxCrx Idx Creates num Number of index creates
idxDlx Idx Deletes num Number of index deletes
idxRdx Idx Reads num Number of index reads
ioResponse Random IO (ms) num The time it takes to perform a random read to from a database file that is not in memory
Lat2LogRd Latch/logRd num The ratio of latches requests to logical reads
LatchReq Latch Reqs num Number of latch requests
LatchTMO Latch Waits num Number of processes waiting for a latch to access information in shared memory
lkDurMS Lk Dura (ms) num Average duration of a lock in milliseconds
LkTblHWM Lock Tbl HWM num Lock table concurrent locks high water mark. This is the highest number of concurrent record locks since the database was started or statistics were zeroed
lkTblpct LkTbl% num Current number of locks as a percentage of the highest allowable number of entries in the lock table (-L startup parameter)
LkTblSz Curr # Locks num Current number of locks in the lock table
Log2Rec LogRd/RecRd num Ratio of logical reads to records reads
LogRd Log Reads num Number of logical record reads
LogWr Log Writes num Number of logical record writes
minChkPtLen   num Length, in HH:MM:SS, of the shortest checkpoint since the beginning of the ProTop session
minChkPtStr   char String version of Min ChkPt Len
ModBufs Mod Bufs num Number of modified buffers
MR   num  
numBI Num BIClstrs num Number of BI clusters in use
oldBI Old BIClstr num Oldest BI cluster in use
OldTRX Oldest TRX char Age of the oldest open transaction as HH:MM:SS
OSRd OS Reads num Number of reads from disk
OSWr OS Writes num Number of writes to disk
otrx   num Age of oldest open transaction in seconds
picaFree   num Number of available Replication message entries
picaUsed pica Used num Number of Replication message entries in use
picaUsedPct pica Used% num Percent of total Replication message entries in use
Rd2Wr LogRd/LogWr num Ratio of logical reads to logical writee
RecCr Rec Creates num Number of record creates
RecDl Rec Deletes num Number of record deletes
RecLk Rec Locks num Current number of record locks
RecRd Rec Reads num Number of record reads
RecUp Rec Updates num Number of record updates
RecWt Rec Waits num Number of record waits
ResrcWt Resrc Waits num Number of resource waits
rm_allocNew New RM num Number of new blocks created in the RM chain
rm_examined Examined num Number of RM blocks examined to see if space is available
rm_frnt2bk Front2Bk num Number of blocks moved from the front of the chain to the back because not enough space was available
rm_fromFree From Free num Number of blocks allocated from the Free chain
rm_fromRM From RM num Number of blocks allocated from the RM chain
rm_rmlocked RM Locked num Number of blocks locked
syncIO Sync IO (sec) num Time required to grow a bi file to 96 MB on the BI file system
syncIOMB (MB/sec) num MB written during Sync IO test
TotBufs   num Total buffers
TRX Commits num Number of transactions commits
TRXUndo Undos num Number of transaction undos
usrExpCS User Exp CS num Client/server 4GL client reads/sec, connecting via across the LAN from another server (not shown - part of commercial ProTop)
usrExpLH User Exp LH num Client/server 4GL client reads/sec, connecting via the localhost connection (not shown - part of commercial ProTop)
usrExpSHMTM   num  
usrExpSHM User Exp SHM num Shared memory 4GL client db reads/second
usrField1   num see Custom Application KPI
usrField2   num see Custom Application KPI
usrField3   num see Custom Application KPI
usrField4   num see Custom Application KPI
usrField5   num see Custom Application KPI
usrField6   num see Custom Application KPI
usrField7   num see Custom Application KPI
usrField8   num see Custom Application KPI
zNumReplAgents Number of Replication Agents num Number of Replication Agents
zusrExpCS ZippyCS num  
zusrExpLH ZippyLH num