"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 |