Description
Accumulates while SQL Server running distributed queries. It is common to see this wait type on instances hosting Linked Servers. Moderate values are expected in this type, if it is the top wait for the instance further investigation is required
Resolved by
DBAs and Developers
Suggested solutions
- Ensure that Linked Servers are configured as per best practice (see additional research below)
- Optimize queries running over Linked Servers
Additional research
MSQL_DQ and PREEMPTIVE_COM_QUERYINTERFACE-Two Sides of the Same Coin
Recommendations for Linked Server Performance Improvement
SQL Server OLEDB Wait Type