Description
Accumulates during certain Distributed Transaction Co-Ordinator (DTC) operations. This wait is rare and currently not documented by Microsoft. If values are excessive see the suggested solutions below
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