Analyzing the States of Checkpoint File Pairs
SQL Server persists data from durable memory-optimized tables in checkpoint file pairs. This appendix demonstrates how to analyze their states using the sys.db_dm_xtp_checkpoint_files view and shows the state transitions through the CFP lifetime.
The sys.db_dm_xtp_checkpoint_files view provides information about database checkpoint files, including their state, size, and physical location. We will use this view extensively in this appendix. Let’s look at the most important columns.