locked
Database Mirrors over distance RRS feed

  • Question

  • Various posts have noted that mirroring over distance is not advisable or that either async connections should be used.

    Are there any limits/recommendations i.e. if two datacenters are a couple of files part with 10GBs fibre links and <50ms response times would this be acceptable for high-availability mirroring?

     

    Tuesday, March 20, 2007 12:14 PM

Answers

  • Hi Andrew,

    I think you have good network links.

    The best thing to do is to test it in synchronous mode first. See what the performance is like.

    If the performance is not acceptable, you can then switch the safety off.

    Please note that Wtiness server should not be used when running with safety off option.

    cheers

    Jag

    Wednesday, March 21, 2007 1:00 PM

All replies

  • Hi Andrew,

    I think you have good network links.

    The best thing to do is to test it in synchronous mode first. See what the performance is like.

    If the performance is not acceptable, you can then switch the safety off.

    Please note that Wtiness server should not be used when running with safety off option.

    cheers

    Jag

    Wednesday, March 21, 2007 1:00 PM
  • Andrew,

    Please include re-indexing  and large bulk inserts in your testing as well.

    cheers

    Jag

    Wednesday, March 21, 2007 1:01 PM
  • jag,

    Thanks for the response,  although I think I will need to look at another solution as mirroring has a very small limit on the number of Databases that can be mirrored (10 recommended, people maxing out at 60) and with a large SharePoint installation the number of content databases can exceed these limits relatively quickly.  

    Options:   More SQL servers (x2 to mirror)  or use Clustering in live datacenter with Log Shipping to redundant center.

    Andrew

    Thursday, March 22, 2007 6:48 PM