Mirroring

Question

Mirroring

kapfundestanley

SSCertifiable

Points: 5637
More actions
November 3, 2011 at 10:03 pm

#250354

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
November 4, 2011 at 1:23 am

This was removed by the editor as SPAM

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

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

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 1

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: 21700 More actions · Answer 2

M&M

SSC-Insane

Points: 21700

November 4, 2011 at 1:49 am

#1403090

Good question, Thank you.

M&M

michael.kaufmann SSCrazy Points: 2816 More actions · Answer 3

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 More actions · Answer 4

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: 5637 More actions · Answer 5

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 More actions · Answer 6

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 More actions · Answer 7

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 More actions · Answer 8

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 More actions · Answer 9

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: 104773 More actions · Answer 10

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: 21700 More actions · Answer 11

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: 281334 More actions · Answer 12

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: 9585 More actions · Answer 13

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.