Difference Between Checkpoint And Lazy Writer


CHECKPOINT vs LAZY WRITER


CHECKPOINT LAZY WRITER
Check point runs in only transaction log file Lazy writer operates from buffer pool
Check point is the logged operation and writes to Tlog file Lazy writer  is the non-logged operation and did not write to Tlog file
Check point can be controlled by user and Sql server engine as well lazy writer only operate by Sql server engine
Check point is the background process which triggers every 3 sec Lazy writer does not have any fixed time line 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 check point 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 sec] No command available

 


 

Leave a Reply

Your email address will not be published. Required fields are marked *