Description
This wait type accumulates while SQL Server is waiting for the Distributed Transaction Co-Ordinator (DTC) to cancel a transaction. Distributed transactions run across multiple database instances and sometimes other platforms like Oracle. If this wait type is high further investigation is required
Resolved by
DBAs
Suggested solutions
- Check the error logs on every instance the transaction is running on. Determine why the transaction is failing and resolve it
- Keep distributed transactions as short as possible
- Ensure that Linked Servers are configured as per best practice (see additional research below)
- Run a Profiler/trace/Extended Event session on each instance participating in the transaction
Additional research
About the SQL Server DTC Wait Type
Recommendations for Linked Server Performance Improvement