Dirty pages are written to disk on the following events.

• Lazy writing is a process to move pages containing changes from the buffer onto disk. This clears the buffers for us by other pages.

• Checkpoint writes all dirty pages to disk. SQL Server periodically commits a CHECKPOINT to ensure all dirty pages are flushed to disk.

• Explicitly issuing a CHECKPOINT will force a checkpoint

 Examples of events causing a CHECKPOINT

1. net stop mssqlserver

2. SHUTDOWN

3. ALTER DATABASE adding a file

• Eager writing – Nonlogged bcp, SELECT INTO, WRITETEXT,UPDATETEXT,BULK INSERT are examples of non-logged operations. To speed up the tasks , eager writing manages page creation and page writing in parallel. The requestor does not need to wait for all the page creation to occur prior to writing pages