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?
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
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.