Lazy writer in SQL Server

Lazy writer

Lazy writer in SQL Server :-

  • Lazy writer check each page header and verify whether all transactions in the pages are committed then pages will be flushed to disk… [Page header contains infusion of whether committed\uncommitted]
  • This is one of the back ground process where works only from BUFFER Cache.
  • Lazy writer works only when system is running with memory pressure or running out of memory.
  • User cannot see or create, manual lazy writer operation in SQL Server
  • We cannot able to capture lazy writer information into SQL Server logs.
  • Lazy writer allocating space for new pages in buffer pool
  • Lazy writer Checking for memory pressure.
  • Lazy writer Only works with buffer pool but not in log file.

Note: prime job of lazy writer is it flush the pages from buffer to disk.



Leave a Reply

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