3

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?

Erik
  • 4,833
  • 4
  • 28
  • 57
Morten Vinther
  • 31
  • 2

2 Answers2

4

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

Community
  • 1
Kin Shah
  • 62,545
  • 6
  • 124
  • 245
0

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.

SELLTSLA
  • 1
  • 1