"Checkpoints" Data Collector
For a detailed discussion of these metrics, see ProTop Real-Time - Checkpoints (k).
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_checkpt | (temptable name) | ||
| apwq | APW Q | num | Number of buffers in the APW queue |
| biWrt | BIWr | num | Number of writes to the BI file |
| biWrtTm | BIWrTm | num | Amount of time spent writing to the BI file |
| ckptClstr | Cluster | num | BI file cluster number of the checkpoint |
| cpLen | Length | char | Length of time required to complete the checkpoint |
| cptq | ChkPtQ | num | Number of buffers in the checkpoint queue |
| DBWrt | DBWr | num | Writes to the database |
| DBWrtTm | DBWrTm | num | Amount of time spent writing to the database |
| dirty | Dirty | num | Number of dirty buffers associated with the checkpoint |
| duration | Duration | num | Time to do the housekeeping of the checkpoint (portion of checkpoint Length) |
| fini | Finish | char | End time of the checkpoint |
| flush | Flushed | num | The number of buffers written to disk at the end of the checkpoint. See below |
| id | Chkpt# | num | Checkpoint Number |
| scan | Scan | num | Number of buffers scanned by APWs during the checkpoint |
| st | Start | char | Start date and time of the checkpoint |
| syncTime | Sync Time | num | Time to write modified database files to disk at the end of a checkpoint |