The MSQL_DQ wait type accumulates while waiting for a distributed query to complete and it is not necessarily indicative of an issue. If MSQL_DQ is one of your top wait types accumulated on your SQL Server instance, you may also see an associated PREEMPTIVE_COM_QUERYINTERFACE wait type. And actually, you may see that the accumulated values […]
Joe Sack
SQL Server Performance Tuning, High Availability and Disaster Recovery Blog
MSQL_DQ and PREEMPTIVE_COM_QUERYINTERFACE–Two Sides of the Same Coin
Posted on: June 29, 2012 12:37 am
AlwaysOn Architecture Guide: Building a High Availability and Disaster Recovery Solution by Using AlwaysOn Availability Groups
Posted on: June 23, 2012 7:45 am
The new “AlwaysOn Architecture Guide: Building a High Availability and Disaster Recovery Solution by Using AlwaysOn Availability Groups” white paper was just published by Microsoft over the weekend. I co-authored this white paper with Sanjay Mishra, Senior Program Manager in the Microsoft SQL Customer Advisory Team. This paper covers one of the three common customer […]
SQL Server 2012 Execution Plan’s NonParallelPlanReason
Posted on: June 12, 2012 10:17 am
SQL Server 2012 introduces a “NonParallelPlanReason” attribute in the QueryPlan element in a query execution plan. This attribute is not officially documented as of this writing, and so I was curious which scenarios this new functionality covered. Take the following example query which runs in parallel on my test SQL Server instance: A few details […]
