syscheckpoint
The syscheckpoint table provides information and statistics about checkpoints.
| Column | Type | Description |
|---|---|---|
| interval | integer | Number of checkpoints since the server was started |
| type | char(12) | Hard or Interval |
| caller | char(10) | Caller of the checkpoint |
| clock_time | integer | Time of day the checkpoint occurred |
| crit_time | float | Time spent waiting for the critical section to be released |
| flush_time | float | Time spent flushing pages to disk |
| cp_time | float | Duration from checkpoint pending until checkpoint done |
| n_dirty_buffs | integer | Number of dirty buffers |
| plogs_per_sec | integer | Number of physical log pages processed in a second |
| llogs_per_sec | integer | Number of logical log pages processed in a second |
| dskflush_per_sec | integer | Number of buffer pool pages flushed in a second |
| ckpt_logid | integer | Unique id of the logical log at the checkpoint |
| ckpt_logpos | integer | Position of the logical log at the checkpoint |
| physused | integer | Number of pages used in the physical log |
| logused | integer | Number of pages used in the logical log |
| n_crit_waits | integer | Number of users who had to wait to enter a critical section |
| tot_crit_wait | float | Duration spent waiting for all users waiting at the checkpoint critical section block |
| longest_crit_wait | float | Longest critical section wait |
| block_time | float | Duration of the checkpoint that blocked the system |