"UsersOfIndex" Data Collector
For a detailed discussion of these metrics, see ProTop Real-TIme - Monitor Users of Index (9).
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_uIdxAct | (temptable name) | ||
idxBlkDl | BlkDl | num | Number of index blocks deleted |
idxCr | Create | num | Number of indexes created |
idxDl | Delete | num | Number of indexes deleted |
idxRd | Read | num | Number of indexes read |
idxRoot | Idx Root | num | Block ID of the index root |
idxSp | Split | num | Number of index references split |
lastUpd | CSC Age | char | If enabled, the number of seconds since the user's Client Statement Cache (CSC) was last updated |
lineNum | Line# | num | If CSC is enabled, line number of the currently executing program |
procName | Program Name | char | If CSC is enabled, name of the curretly executing program |
usrname | User Name | char | User name associated with the Usr# |
usrNum | Usr# | num | Unique user number reference used by Progress schema tables |