"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 |
| server-pid | num | PID of the server process | |
| sever-type | char | TYpe of server | |
| 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 |