UsersOfIndex Data Collector

"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