PREEMPTIVE_OS_DTCOPS

Description

This wait type accumulates while SQL Server is waiting for the Distributed Transaction Co-Ordinator (DTC) to complete Operating System actions. Distributed transactions run across multiple database instances and sometimes other platforms like Oracle. This wait is common for instances running DTC and low values do not indicate a problem. If this wait type is high further investigation is required

Resolved by

DBAs

Suggested solutions

  1. Check the error logs on every instance the transaction is running on. Determine why the transaction is failing and resolve it
  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

About the SQL Server DTC Wait Type
Recommendations for Linked Server Performance Improvement

⇐ Back to index