MS DTC Architecture
In general, each Microsoft SQL Server that you want to be included in your high availability distributed transaction topology must have an associated distributed transaction coordinator (MS DTC).
As has been explained, it is MS DTC that allows your applications to extend transactions across two or more instances of MS SQL Server (and participate in transactions managed by transaction managers that comply with the X/Open DTP XA standard). Think of MS DTC as the primary coordinator for these distributed transactions. MS DTC enlists (includes) and coordinates all SQL Servers (linked servers) that are part of a single distributed transaction as is shown in Figure 8.2
SQL Server will automatically promote a local transaction to ...
Get Microsoft® SQL Server High Availability now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
