DTCPNTSYNC

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

  1. Check the error logs on every instance the transaction is running on
  2. Keep distributed transactions as short as possible
  3. Ensure that Linked Servers are configured as per best practice (see additional research below)
  4. 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

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