checkpoint is a database event. when checkpoint happens, all dirty blocks(pages) in the memory are written to database data files.

learn more… | top users | synonyms

1
vote
0answers
137 views

What is an incremental checkpoint (in the context of indirect checkpoints)?

I was using extended events to trace checkpoint activity of a database with indirect checkpoints enabled. The event stream looks like this: And the details of the selected event are: The ...
0
votes
0answers
46 views

Log not truncating due to xpt_checkpoint

I have a DB on a SQL Server 2014 instance. I have a memory-optimized filegroup, but as yet, no memory optimized tables. I also have a FILESTREAM filegroup, which contains 1 FILETABLE and a Primary ...