none
SQL 2012 Always On Availability Groups RRS feed

  • Question

  • Has anyone configured FIM SYnc, FIM Service and MSF in SQL 2012 Always On Availability groups

    I do not believe we can configure the SQL connection string for FIM Sync or FIM Service to include "multisubnetfailover"

    TIA

    Nigel

    Wednesday, January 15, 2014 4:08 AM

All replies

  • Did you ever find out if this is supported?  I haven't found any release notes stating that it is.

    Cheers!

    Wednesday, May 14, 2014 5:20 PM
  • I commented on this here:https://social.technet.microsoft.com/Forums/en-US/64f55628-3b5d-4d16-9044-dcbe7053581d/lack-of-support-for-fim-database-mirroring?forum=ilm2

    Additional comments:

    SQL Server Always On Failover Cluster Instances should be supported just as SQL Clustering is supported.

    SQL Server Always On Availability Groups are not supported, just as Database Mirroring in synchronous mode (which is required for automatic failover) is not supported. I can't find authoritative statements of this on the web. But I know this to be the case.

    Ultimately, the reason for lack of support for mirroring (for automatic failover or in synchronous mode) is that the product group has said so (in conferences and webinars). Meaning the product group has not tested it or has and decided that it doesn't work or adds risk.

    Possible underlying reasons:

    1) To do automatic failover with mirroring or Availability groups you must edit the connection string. The way FIM builds the connection string out of the components in the registry don't permit this.

    2) Running mirroring in synchronous mode slows down performance in two ways: first is the additional traffic to send it to the mirror partner (or replica), second and most important is that synchronous requires that the primary not truly commit the transaction until it has been committed to the secondary which means transactions take longer. For some products this can result in an unacceptable performance degradation.

    Hopefully, MIM will support Availability groups.


    David Lundell, Get your copy of FIM Best Practices Volume 1 http://blog.ilmbestpractices.com/2010/08/book-is-here-fim-best-practices-volume.html

    • Proposed as answer by Peter_Stapf Monday, October 27, 2014 7:45 AM
    Friday, October 24, 2014 11:48 PM
  • Just in case everybody on this thread missed it

    As of Build 4.4.1459 (a hot fix for MIM SP1) and later SQL 2016 always on availability groups and mirroring are supported



    David Lundell, Get your copy of FIM Best Practices Volume 1 http://blog.ilmbestpractices.com/2010/08/book-is-here-fim-best-practices-volume.html

    Sunday, September 9, 2018 5:32 AM