Description
This wait type accumulates while SQL Server is waiting for the Distributed Transaction Co-Ordinator (DTC) to resolve a transaction. Transaction resolution is performed by the transaction’s master database. Distributed transactions run across multiple database instances and sometimes other platforms like Oracle. This wait type is uncommon and if values are excessive then further investigation is required
Resolved by
DBAs
Suggested solutions
- Check the error logs on every instance the transaction is running on
- 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
Distributed Transactions
About the SQL Server DTC Wait Type
Recommendations for Linked Server Performance Improvement