This new DMV is not currently documented, but below shows it in action:
--create test database CREATE DATABASE d GO -- allow in-memory on database ALTER DATABASE d ADD FILEGROUP [fg] CONTAINS MEMORY_OPTIMIZED_DATA; ALTER DATABASE d ADD FILE (NAME = f, FILENAME = N'C:\temp\') TO FILEGROUP [fg]; USE d; --create test table CREATE TABLE t (c1 int INDEX i1 NONCLUSTERED, c2 varchar(10)) WITH (MEMORY_OPTIMIZED = ON, DURABILITY = SCHEMA_ONLY); --view sys.dm_db_xtp_checkpoint_internals SELECT * FROM sys.dm_db_xtp_checkpoint_internals; --create a checkpoint CHECKPOINT; --view sys.dm_db_xtp_checkpoint_internals SELECT * FROM sys.dm_db_xtp_checkpoint_internals; --create a checkpoint CHECKPOINT; --view sys.dm_db_xtp_checkpoint_internals SELECT * FROM sys.dm_db_xtp_checkpoint_internals;
