• Tom.Thomson (3/31/2010)


    And I see the MS design does include flushing already dirty pages to disc despite Hugo's suggestion that this is not a useful thing to do.

    Yes, I noticed that as well. And was a bit surprised by it.

    I'm glad Paul was able to find and post such a detailed description of the process. Thanks, Paul!


    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/