Home Forums SQL Server 2008 SQL Server 2008 Administration Buffer Pool RE: Buffer Pool

  • November 10, 2012 at 7:44 am

    #1557907

    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.

    Thanks Gail

    Please help me understand this process

    When a checkpoint runs, it doesn't actually remove the page from memory, it marks the page as clean? Does this mean that it removes the contents of the page?

    Thanks