Description
This wait type accumulates while running requests through the Distributed Transaction Co-Ordinator (DTC). Distributed transactions run across multiple database instances and sometimes other platforms like Oracle. If this wait type is high it indicates these transactions could be a bottleneck
Resolved by
DBAs and Developers
Suggested solutions
- 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. Determine which transactions are taking the longest and optimize
Additional research
About the SQL Server DTC Wait Type
Recommendations for Linked Server Performance Improvement