Target Recovery Interval and Indirect Checkpoint

  • Igor Micev

    SSC-Dedicated

    Points: 33108

    Comments posted to this topic are about the item Target Recovery Interval and Indirect Checkpoint

    Igor Micev,
    My blog: www.igormicev.com

  • Robert Sterbal

    SSChampion

    Points: 10952

    Nice article.

    Do you plan on continued testing with different workloads and time frames? Will you publish those results as well?

    412-977-3526 call/text

  • Igor Micev

    SSC-Dedicated

    Points: 33108

    robert.sterbal 56890 (7/21/2016)


    Nice article.

    Do you plan on continued testing with different workloads and time frames? Will you publish those results as well?

    The workload is pretty much similar during the day, so I could not experiment with quite different workloads on my staging.

    The changes are already done on my production environments and I'm satisfied from the improvement. I got similar results on production because we use the same feed (live) there as well.

    I'll continue this work with another client that has bigger databases (300 GBs+) so I'll publish other results too, but some time later.

    Igor Micev,
    My blog: www.igormicev.com

  • Igor Micev

    SSC-Dedicated

    Points: 33108

    As robert.sterbal 56890 asked for extra screens from perfmon.exe, I'm doing that again. Now for a 500GB database on a server with even faster disks (15K rpm). The gain is similar as the one in the article.

    Before changing TARGET_RECOVERY_TIME:

    After changing TARGET_RECOVERY_TIME:

    Igor Micev,
    My blog: www.igormicev.com

Viewing 4 posts - 1 through 4 (of 4 total)

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