sys.dm_db_xtp_checkpoint_files

in-memory
#in-memory#dmv

Description

Displays information about In-Memory OLTP checkpoint files, including file size, physical location and the transaction ID. A memory-optimized file group internally uses append-only files to store inserted and deleted rows for in-memory tables. There are two types of files. A data file contains inserted rows while a delta file contains references to deleted rows.

Syntax

sys.dm_db_xtp_checkpoint_files