Difference Between Checkpoint And Lazy Writer

 

CHECKPOINT vs LAZY WRITER

CHECKPOINT	LAZY WRITER
Checkpoint runs in an only transaction log file	The lazy writer operates from a buffer pool
The checkpoint is the logged operation and writes to Tlog file	The lazy writer  is the non-logged operation and did not write to Tlog file
Checkpoint can be controlled by user and SQL server engine as well	The lazy writer only operate by the Sql server engine
The checkpoint is the background process which triggers every 3 sec	The lazy writer does not have any fixed timeline and only occurs when there is memory pressure in the buffer pool
We can able to track checkpoint into Sql server logs by enabling the trace 3502	Lazy writer information cannot be able to track into SQL Server logs.
In memory, free pages list not taken care and kept free list	In memory, free pages list  taken care and kept free list
We can fire a query to see checkpoint information by using Select * from:: fn_dblog (null, null) WHERE [Operation] like ‘%CKPT’	We don’t have any query to see lazy writer information
Command: Checkpoint  [time in a sec]	No command available