Dynamically swithing between sync and async mirroring depending on the system Load and mirroring delay RRS feed

  • Question

  • We experienced significant delays in Sync mode on our busy oltp database. 

    At the time, the only way of getting decent performance was to switch to Async which obviously increases the possibility of data loss and forces us to slower, manual failovers.

    I was wondering if anyone has experimanted with dynamically ALTERING the mirror from Safety FULL  to Safety OFF when the system gets busy?



    Wednesday, June 20, 2012 8:22 PM


  • I would rather go the way to find out why it is slow to start with before you risk loosing data...

    And yes, we have experimented with it, but the point is: What is the RPO? If I am good with loosing data I can stay with Async permanently... If the RPO does not allow that switching it would be suicide to start with...

    Thursday, June 21, 2012 1:00 AM