IndexActivity Data Collector

"IndexActivity" Data Collector

For a detailed discussion of these metrics, see ProTop Real-Time - Index Activity (i) and ProTop Trends - Table and Index Statistics.

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_idxAct     (temptable name)
idxAreaNum Area# num Database area containing the index
idxBlkDl BlkDl num Number of index block deletes
idxBlks Blocks num Size of the index in blocks
idxCr Create num Number of index entries created
idxDl Delete num Number of index entries deletions
idxLvls Lvls num Number of levels from index root to leaf nodes
idxName Index Name char Name of the index
idxNote Note char Flags on the index (P)rimary, (U)nique, (W)ord, and (i)nactive
idxNum Idx# num Unique index reference from Progress schema table _index
idxPool BX char Blocks assigned to the primary buffer pool (B1) or alternate buffer pool (B2)
idxRd Read num Number of index reads
idxRoot Idx Root num Block ID of the index root
idxSp Split num Number of index block splits
idxUtil Util num Percent utilization of block space by the index