DTC_TMDOWN_REQUEST

Description

This wait type accumulates when SQL Server receives a timeout when trying to access the Distributed Transaction Co-Ordinator (DTC). This typically occurs when the DTC service is offline. This wait type is uncommon. Any values indicate there could be an issue with the DTC and investigation is recommended

Resolved by

DBAs

Suggested solutions

  1. Check the error logs on every instance the transaction is running on
  2. Check the Windows error log for any DTC related issues

Additional research

Distributed Transactions

See more

Consider using ApexSQL Monitor, a Windows and SQL Server monitoring tool able to track SQL Server wait types, including the individual query wait statistics

⇐ Back to index