Post reply

Does loss of a witness affect the response of the principal

  • July 21, 2016 at 8:15 am

    #328562

    Apologies if this question has been asked before, but I wasn't able to find a thread with this exact question.

    In the following setup :

    SQL 2008, Mirroring - High Safety with automatic failover

    The witness becomes unavailable (i.e. neither the primary or mirror can reach it) but the primary and mirror can communicate with each other.

    Will there be any impact on the performance of the primary, or does it continue to service requests as normal?

    From what I've read, so long as there is a quorum, which there is in this scenario, then the primary will simply carry on as normal and there will be no impact on clients.

  • July 21, 2016 at 8:22 am

    #1891337

    ianharris2 (7/21/2016)

    does it continue to service requests as normal?

    Yes.

    The only thing losing the witness does is remove the automatic failover ability.

    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

  • July 21, 2016 at 8:31 am

    #1891345

    Thanks for confirming.

  • August 2, 2016 at 10:12 am

    #1893284

    Also bear in mind, if the principal and mirror then become disconnected too, the principal will go offline.

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

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

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