SQLSACT (2/26/2013)
So even if SQL is installed as non clustered, DTC can still become involved somehow
DTC is not just used for SQL Server, the OS uses it for remote calls too.
SQLSACT (2/26/2013)
If that's the case, why when dealing with Clustered instances of SQL Server do we have to explicitly create a DTC component in the Cluster?Thanks
In a clustered environment, a clustered DTC is used to recover inflight transactions. Take the following scenario:
Node1 and Node2 have a clustered instance INST1 which is currently active on Node1. DTC is local and not clustered.
A remote transaction is started and during the transaction the instance goes offline and fails over to Node2. The SQL instance is no longer local to the stand alone DTC and cannot connect to recover the inflight transaction.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉