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
See more
Check out SpotLight, a free, cloud based SQL Server monitoring tool to easily detect, monitor, and solve SQL Server performance problems on any device