Question: what is the difference between checkpoint and lazy writer in sql server?
Answer: There is a difference between the SQL Server CHECKPOINT and the Lazy writer process. CHECKPOINT does not remove the dirty pages from the memory. ... The Lazy writer process checks for the pages in the buffer pool and flushes them to the disk. It removes both the clean and dirty pages from the buffer cache.