question

narendba avatar image
narendba asked

what are the frequent issues we facing on mirroring?

Hi All, i'm new to mirroring, So can any one mention what are the frequent issues we are facing in mirroing and at the time configure the mirroring also? Just a count of replies on this question and will share our experiances what issues faced and how we solved it?
sql-server-2008
4 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Are this question and this one http://ask.sqlservercentral.com/questions/108110/what-are-the-frequent-issues-we-facing-on-logshipp.html, homework or interview questions? Just so we can tag appropriately.
0 Likes 0 ·
It's interview questions and need some practice before we will accept the solution..
0 Likes 0 ·
Interview questions you're going to be asking or ones you've been asked? If the latter, you should let us know that. We don't want to help people cheat their way into jobs.
0 Likes 0 ·
The site does run on votes. So please mark all helpful answers by clicking the thumbs up and if any one answer lead to a solution mark that by clicking on the check mark.
0 Likes 0 ·
ramesh 1 avatar image
ramesh 1 answered
1. when there is a network then mirroring endp piont needs to be restarted (in SQL Server 2008 no need to do it) 2. installing Service Packs while installing SQL Server or windows patching 3. adding a ndf file to the primary Server 4. moving databases between the Drives 5. shrinking the log(ldf) files
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Hi Ramesh, That's great.. Can I know how to overcome on those above issues and what is the procedure can we follow...
0 Likes 0 ·
And what is "endpoint" exactly and what is the problem will get if it is not in "live"
0 Likes 0 ·
ramesh 1 avatar image
ramesh 1 answered
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

That's just explanation of how to configure the mirroring and it's good one... But Can you creat an issue and give the solution with how to comeout of it for the following points which you mentioned in above... 1.when there is a network then mirroring endp piont needs to be restarted (in SQL Server 2008 no need to do it) 2.installing Service Packs while installing SQL Server or windows patching 3.adding a ndf file to the primary Server 4.moving databases between the Drives 5.shrinking the log(ldf) files
1 Like 1 ·
Blackhawk-17 avatar image
Blackhawk-17 answered
A big issue I've seen is when developers use tables in the database being mirrored for temporary work rather than using temp dB. Since the transaction must commit on the mirror before the primary there is unnecessary data being sent across the network and this increases the duration of your transaction. Another issue is using under-powered hardware for the mirrored instance. Again avoidable delays are introduced. A quick rule of thumb is that every transaction will take twice as long to complete when participating in a mirror partnership.
4 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

@narendba - look up mirroring in Books Online
1 Like 1 ·
As per the first point it's asynchronous mirroring right? If Yes I didn't get why you draged tempdb into picture..? And another question if transaction failed in Mirror how it will be roolback in Principle? Can you give me an explanation with example or some shat brief
0 Likes 0 ·
What type of unnecessary data is moving from principle to mirror server? And at 3rd point why you mentioned "every transaction will take twice as long to complete when participating in a mirror partnership"... Why "transaction twice" would be happend?
0 Likes 0 ·
Miiroring is generally synchronous unless using Enterprise Edition.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.