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