locked
Mirrorring or Clustering SQL for CRM Dynamics? RRS feed

  • Question

  • I am setting up a new CRM dynamics infrastructure with 2 frontend and 2 SQL backend.

    We need HA .

    The discussion is whether to :

    -cluster SQL servers in Active-Active mode ( would require for enterprise license for windows and/or SQL)

      or

    -Mirror both SQL using Active-Passive mode.

    I pretty sure the cluster would give higher RTO , for a higher price with more management.

    and Mirror would be slightly lower RTO but cheaper and with less configuration and management work .

    Does someone has experienced these 2 options and can provide some insight ?

    Friday, June 24, 2011 2:13 PM

Answers

  • The first point to make is that CRM will only use a SQL cluster as an Active-Passive cluster, and you only need Windows and SQL Standard Edition. The additional cost of clustering is the SAN hardware. The other main differnece is that mirroring can add performance overhead, especially in synchronous mode.

    There's nothing particularly unusual about CRM when it comes to deciding on the SQL high availability options, If you haven't seen it already, the SQL high availiability white paper has some useful information


    Microsoft CRM MVP - http://mscrmuk.blogspot.com  http://www.excitation.co.uk
    • Marked as answer by SafeAlex Wednesday, June 29, 2011 9:49 AM
    Friday, June 24, 2011 6:34 PM
    Moderator

All replies

  • I've set up mirroring with CRM. It was incredibly easy and worked great. I can't speak to clustering.

    For disaster recovery I also incorporated transaction log shipping to an offsite SQL Server, too.


    Lucas Alexander http://twitter.com/lucas_is
    Friday, June 24, 2011 5:53 PM
  • The first point to make is that CRM will only use a SQL cluster as an Active-Passive cluster, and you only need Windows and SQL Standard Edition. The additional cost of clustering is the SAN hardware. The other main differnece is that mirroring can add performance overhead, especially in synchronous mode.

    There's nothing particularly unusual about CRM when it comes to deciding on the SQL high availability options, If you haven't seen it already, the SQL high availiability white paper has some useful information


    Microsoft CRM MVP - http://mscrmuk.blogspot.com  http://www.excitation.co.uk
    • Marked as answer by SafeAlex Wednesday, June 29, 2011 9:49 AM
    Friday, June 24, 2011 6:34 PM
    Moderator
  • David, when you say CRM will only use SQL Cluster as Active-Passive cluster, does it apply to CRM 4.0 only or to CRM 2011 as well? 

    We have one deployment where the database is getting bigger and the number of users are getting larger and we are thinking that rather than upgrade the hardware of SQL Server, we simply create a SQL Cluster and allow Active-Active cluster so that users can be split among two or more SQL Servers. Is this scenario possible?

    Monday, June 27, 2011 4:37 PM
  • Both CRM 4.0 and 2011 only work on Active-Passive SQL clusters. This is more a limitation of SQL, than CRM as a database is the smallest unit for partitioning load across active nodes in a SQL cluster - you can't have 2 SQL nodes concurrently accessing the same database


    Microsoft CRM MVP - http://mscrmuk.blogspot.com http://www.excitation.co.uk
    Monday, June 27, 2011 5:49 PM
    Moderator
  • thks for the feedback

     

    Wednesday, June 29, 2011 9:49 AM