MSQL_DQ

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

  1. Ensure that Linked Servers are configured as per best practice (see additional research below)
  2. 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

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