08 March,2013 by Jack Vamvas
SQL Server Books online defines the DTC wait stat type as “Occurs when a task is waiting on an event that is used to manage state transition. This state controls when the recovery of Microsoft Distributed Transaction Coordinator (MS DTC) transactions occurs after SQL Server receives notification that the MS DTC service has become unavailable.
This state also describes a task that is waiting when a commit of a MS DTC transaction is initiated by SQL Server and SQL Server is waiting for the MS DTC commit to finish.”
Related wait types are : dtc_state, preemptive_transimport, preemptive_dtc_enlist
1) Analyse the process information – isolate the transaction and analyse any other issues.Use the script on SQL Server – SQL Server – Current queries executing on SQL Server
2) A good source of information can be MS DTC GUI – read more on MS DTC and sys.dm_tran_active_transactions