SQL WAIT TYPE – DTC and how to reduce it

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

 Troubleshooting Tips

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

Read More


SQL WAIT TYPE – OLEDB and how to reduce it

SQL Server – LCK_M_IS and how to reduce it - sql wait type

Author: Jack Vamvas (http://www.sqlserver-dba.com)


Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.


Post a comment on SQL WAIT TYPE – DTC and how to reduce it

sqlserver-dba.com | SQL Server Performance Tuning | SQL Server DBA:Everything | FAQ | Contact|Copyright & Disclaimer