Checkpoint tries to write as many pages as fast as possible. Lazy writer tries to write as few as necessary.
Hey Gail thanks for the reply.
Now it is getting a bit for confusing for me if my understanding is right.
If I decide to set a recovery interval which will in turn affect the point where the checkpoint occurs then will the Lazywriter flush the dirty pages to the disk even though it does NOT feel memory pressure or wait for the checkpoint to occur or will itself flush them if it feels memory pressure ?
Also in your blog you stated
It does this to keep a certain amount of free pages available within the buffer pool for data that may be requested by other queries.
Can you please let me know what are those free pages in the buffer pool ?
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server