Home Forums SQL Server 2014 Administration - SQL Server 2014 What happens when the number of dirty pages grows beyond the number of pages in the buffer cache? RE: What happens when the number of dirty pages grows beyond the number of pages in the buffer cache?

  • March 3, 2015 at 5:57 am

    #1781327

    This may help: http://www.sqlskills.com/blogs/paul/how-do-checkpoints-work-and-what-gets-logged/

    Notably:

    All dirty data file pages for the database are written to disk (all pages that have changed in memory since they were read from disk or since the last checkpoint), regardless of the state of the transaction that made the change.