MSDTC Recommendations on SQL Failover Cluster

The purpose of the following FAQ (Frequently Asked Questions) is to address common questions with MSDTC (Microsoft Distributed Transaction Coordinator) when used with SQL Server Failover Clustered instances to include current recommendations and best practices.   Index Purpose of this MSDTC FAQ.   What is MSDTC? Do we need MSDTC for SQL Installation? Is MSDTC Supported when using AlwaysON Availability…

13

Not-Supported: AGs With DTC/Cross-Database Transactions

When the topic of cross-database and/or DTC transaction support, under an Availability Group, comes up the quick response is NOT SUPPORTED!   This is a true statement and the conversation tends to then focus on – ‘but why’?’  In fact, some DBAs have tested various forms of these transaction types and not encountered errors. The issue…