View Checkpoints
Use this page to review information about the checkpoints.
A checkpoint is a point in time in the log when a known and consistent state for the database system is established.
The page displays the following information for each checkpoint:
- Interval
- The checkpoint interval ID.
- Type
- Type of checkpoint: blocking or non-blocking.
- LSN
- The log sequence number; that is, the logical log position where the checkpoint is recorded.
- Trigger
- The event that triggered the checkpoint.
- Time
- The time that the checkpoint occurred.
- Block Time
- The length of time that the checkpoint blocked the system.
- Crit Time
- The length of time transactions spent waiting for the critical section to be released.
- Flush Time
- The length of time spent flushing the pages to disk.
- Ckpt Duration
- The total checkpoint duration in seconds from the request time to the checkpoint completion.
- # Dirty Buffers
- The number of dirty buffers flushed to disk during the checkpoint.
- # Wait
- The number of transactions that had to wait to enter a critical section.