Interview Questions
1. What is LazyWriter?
Lazywriter also flushes dirty pages to disk. SQL Server constantly monitors memory usage to assess resource contention (or
availability); It’s job is to make sure that there is a certain amount of free space available at all times. As part of this process,
when it notices any such resource contention, it triggers LazyWriter to free up some pages in memory by writing out dirty pages
to disk. It employs Least Recently Used (LRU) algorithm to decide which pages are to be flushed to the disk.
Submit an interview question
Submitted questions and answers are subject to review and editing, and may or may not be selected for posting, at the sole discretion of w3Sniff.
Get Started
Comments
Leave a Comment