Post reply

Backups and Buffer Pool

  • January 23, 2015 at 8:07 am

    #300556

    Hi all

    I am sure I have seen in the past in a monitoring tool that PLE drops off to 0 whenever we do a backup. I was doing some reading around this however and found something that said backups use a different portion of memory external to the buffer pool (min\max settings).

    Is this correct and how can I tell how much memory will be required for a backup?

    Thanks

  • January 23, 2015 at 8:46 am

    #1772677

    Backups do not run through the buffer pool. They use memory outside of that. Look up 'Backup Buffers' for more details

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • January 23, 2015 at 11:48 am

    #1772779

    I do recommend you to do this on a test environment 1st, but you can test how much memory backups consume with these flags

    TRACE FLAG 3605:

    TRACE FlAG 3213:

    Fire a backup. Then check the buffer count and available memory logged in SQL error log.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply