Checkpoints Data Collector

"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