GilaMonster (11/9/2012)
SQLSACT (11/9/2012)
I'm trying to understand what happens to clean pages in the buffer pool (when a select statement brings pages into the buffer pool).
What happens to the pages once the select statement is done with them?
Nothing.
Neither checkpoint nor lazywriter 'removes' dirty pages from the buffer pool. They just write the changes back to disk so that the pages are considered clean.
Ok
Now I'm really confused
The way I understood it is:
>> Insert, Update or Delete statement is received by SQL Server
>> Required pages are copied from disk into buffer pool
>> Changes are made to affected pages
>> Checkpoint/Lazy Writer process writes the pages back to disk, replacing the original page on disk.
Am I missing something here?
Thanks