We're heading into a new infrastructure:

HyperV, Violin storage & dualsite setup

We're looking into AlwaysOn for dual site, but we are using DTC on many of our systems.

Do you know if the issues with SQL2014 AlwaysOn/DTC only are releated to syncronous AG's?

  • @morten, welcome to the professional site to enthusiastic one. Kindly elaborate few details about your subject matter. – Md Haidar Ali Khan Sep 9 '15 at 19:42
  • The question is: Are there any difference in the support for DTC if you choose to do asyncronous AlwaysOn? I assume that the DTC is only on play during syncronous AlwaysOn!? – Morten Vinther Sep 14 '15 at 11:28

Do you know if the issues with SQL2014 AlwaysOn/DTC only are releated to syncronous AG's?

There is a limited support for DTC with AlwaysON running SQL Server 2016 Community Technology Preview 2 (CTP2). See : Cross-Database Transactions Support For Database Mirroring or AlwaysOn Availability Groups (SQL Server)

For SQL Server 2014 and earlier, DTC is not supported for AlwaysON or DB Mirroring.

Also, refer to Brent's answer : AlwaysOn AG, DTC with failover

  • 1
    +1 for dtc is not supported for alwayson or db mirroring. – Md Haidar Ali Khan Sep 9 '15 at 19:37

We currently are using it and have DTC in place and have not saw any issues. With that being said we have not had the bulk of our user base start to use the secondary replicas. We are slowly starting to move reporting and read related logic to the secondary replicas.

  • Have you tested failovers since you are using DTC with AlwaysON ? – Kin Shah Sep 9 '15 at 20:04
  • 1
    Are you saying you are actually using it directly, or just that the MSDTC service is running? – Aaron Bertrand Sep 9 '15 at 20:43
  • The MSDTC service is running is all servers in the AG, we have not tested fail over so far. We are waiting on a extended maintenance window in the coming weeks to test fail over. – SELLTSLA Sep 10 '15 at 21:11

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.