locked
Experience with SharePoint and Database Mirroring? RRS feed

Answers

  • I would normally expect that high-safety mode is more latent that high-performance mode as the former is synchronous, but you may only see that if you plan to fail-over between sites or don't use a dedicated LAN for mirror traffic.  That said, SQL 2005 testing showed little difference between the two until the rate of transactions significantly increased under formal testing as shown here, or the distance between mirror and principal increased over LAN/WAN. I've not seen metrics for SQL 2008.

    http://technet.microsoft.com/en-us/library/cc917681.aspx

    The key for any planning in relation to Sharepoint would probably be to use more DB servers and offload transactions if you're usage profile for Sharepoint was significant write transactions.



    Regards John Timney http://www.johntimney.com
    Monday, October 31, 2011 10:43 AM

All replies

  • I would normally expect that high-safety mode is more latent that high-performance mode as the former is synchronous, but you may only see that if you plan to fail-over between sites or don't use a dedicated LAN for mirror traffic.  That said, SQL 2005 testing showed little difference between the two until the rate of transactions significantly increased under formal testing as shown here, or the distance between mirror and principal increased over LAN/WAN. I've not seen metrics for SQL 2008.

    http://technet.microsoft.com/en-us/library/cc917681.aspx

    The key for any planning in relation to Sharepoint would probably be to use more DB servers and offload transactions if you're usage profile for Sharepoint was significant write transactions.



    Regards John Timney http://www.johntimney.com
    Monday, October 31, 2011 10:43 AM
  • Thanks for that. This is an extremely interesting article. Before closing this thread as answered, hopefully someone who uses this setup replies.

    To me it appears that failover clustering still is the preferred choice, strangely enough, while the Exchange server world has moved away from this kind of HA and full embraced database mirroring.


    MCTS: Messaging | MCSE: S+M
    Wednesday, November 2, 2011 6:31 AM