Analyzing the States of Checkpoint File Pairs

  • Dmitri Korotkevitch


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.

Copyright information

© Dmitri Korotkevitch 2015

Authors and Affiliations

  • Dmitri Korotkevitch
    • 1
  1. 1.FLUS

Personalised recommendations