Mirroring

  • kapfundestanley

    SSCertifiable

    Points: 5627

    Comments posted to this topic are about the item Mirroring

    “When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris

  • This was removed by the editor as SPAM

  • Koen Verbeeck

    SSC Guru

    Points: 258938

    Nice question, thanks.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • M&M

    SSC-Insane

    Points: 21679

    Good question, Thank you.

    M&M

  • michael.kaufmann

    SSCrazy

    Points: 2816

    Thanks for this question.

    As usually, the devil is in the details--should have read the question properly before answering :Whistling:

  • rfr.ferrari

    SSCertifiable

    Points: 6879

    good question! thanks!!!


    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!
  • kapfundestanley

    SSCertifiable

    Points: 5627

    Thank you all,that's the first question i have contributed and like this.

    “When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris

  • Mattrick

    Ten Centuries

    Points: 1176

    Thanks for the question.

    I am not sure I agree that the Witness is not applicable, though. According to Microsoft's documentation, you can setup a witness in High Performance mode, but it provides no benefit and introduces additional risk. Source (Impact of Witness Section):

    I have never personally tried to create a witness in High Performance mode, so I don't know if there are benefits that the documentation neglects to mention. Does anyone more versed care to share some knowledge in this matter?

    Thanks,

    Matt

  • Ron McCullough

    SSC Guru

    Points: 63877

    A good question, glad I had my first cup of morning coffee before attempting to answer. Rather surprised at the low percentage (34%) of correct answers. So congratulations to the author as the QOD not only tests ones knowledge, but teaches those who do not know the subject and this question will teach many.

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • tilew-948340

    Hall of Fame

    Points: 3431

    bitbucket-25253 (11/4/2011)


    A good question,... So congratulations to the author as the QOD not only tests ones knowledge, but teaches those who do not know the subject and this question will teach many.

    ditto!

  • SanDroid

    SSChampion

    Points: 10068

    Good Question!

    Thanks for the easy Friday question.

    I also find it interesting that only 35% so far have selected the correct answer.

  • TomThomson

    SSC Guru

    Points: 104772

    Nice, good, easy question.

    I forgot to drink lunch before answering, so my inadequately lubricated brain got it wrong.

    Tom

  • M&M

    SSC-Insane

    Points: 21679

    Mattrick (11/4/2011)


    Thanks for the question.

    I am not sure I agree that the Witness is not applicable, though. According to Microsoft's documentation, you can setup a witness in High Performance mode, but it provides no benefit and introduces additional risk. Source (Impact of Witness Section):

    I have never personally tried to create a witness in High Performance mode, so I don't know if there are benefits that the documentation neglects to mention. Does anyone more versed care to share some knowledge in this matter?

    Thanks,

    Matt

    Thanks for sharing this information. I didn't know that we could use a witness server in high performance mode. Not sure about the benefits though. Also, why would we need to introduce this witness server in high performance mode if a quorum needs to be maintained between either principal or mirror for the setup to be functional.

    M&M

  • SQLRNNR

    SSC Guru

    Points: 281210

    Thanks for the question.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • jeff.mason

    SSCrazy Eights

    Points: 9555

    Mattrick (11/4/2011)


    Thanks for the question.

    I am not sure I agree that the Witness is not applicable, though. According to Microsoft's documentation, you can setup a witness in High Performance mode, but it provides no benefit and introduces additional risk. Source (Impact of Witness Section):

    I have never personally tried to create a witness in High Performance mode, so I don't know if there are benefits that the documentation neglects to mention. Does anyone more versed care to share some knowledge in this matter?

    Thanks,

    Matt

    A witness server's only purpose in life is to help negotiate automatic failover. If automatic failover is impossible, as is the case with high performance mode, then there is no reason to have a witness server, and so it truly is not applicable.

Viewing 15 posts - 1 through 15 (of 21 total)

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