hi....

in interview to day............

i said " check point is the process flushing out data from buffer cache to to disk" immediately he asked what is lazy writer  and dirty reads ..?  can any one explain in simple terminology?

I'll take one at the time

dirty reads: read data that is modified by another transaction that is not yet committed

lazy writer: process in SQL server that writes portions of dirty pages(modified pages in memory) to disk whenever any pressure is on memory

check point: process in SQL server that writes ALL dirty pages(modified pages in memory) to disk at regular intervals

Thank you ....Geert.

i got extaly point...so here  difference between  check point and lazy writer..

lazy writer depend on memory

check point is depends time interval

plus checkpoint writes ALL dirty pages to disk and chackpoint will also clear the transactionlog when your database is in SIMPLE recovery mode

Thank you geert.

Nice. Short and sweet.

I am moving it to Tools.