First published on MSDN on Mar 06, 2017
Recently, I looked an In-Memory OLTP issue with Principal Software Engineer
Bob Dorr
who is still my office neighbor. After r...
Updated Jan 16, 2019
Version 2.0
Blog Post
3 MIN READ
Why am I getting so many checkpoint files when I have In-Memory OLTP enabled?
"Even without any memory optimized tables,number of checkpoint files keep going up every time we issue a checkpoint"
Is there any reason that this keeps on happening even after the table is dropped? What is stored in those checkpoint files and why are they there even in a situation where there is no memory optimized tables?
EDIT:
Found my answer here https://download.microsoft.com/download/8/3/6/8360731A-A27C-4684-BC88-FC7B5849A133/SQL_Server_2016_In_Memory_OLTP_White_Paper.pdf