Regular Session

Parallel Query Execution [DBA-404]

Speaker(s)Paul White

Duration: 75 minutes

Track: Enterprise Database Administration & Deployment

Parallel execution is one of the least understood areas of SQL Server, despite the feature being in the product since version 7.0. This session will demonstrate how parallel execution works, how to interpret parallel execution plans, and how to recognize and debug problems particular to parallel execution.

You’ll see intra-query parallel deadlocks and a parallel query that executes faster using fewer resources than the equivalent single-threaded plan. You’ll also discover the true meaning of the misunderstood CXPACKET wait type and learn how to force parallel execution for that large, complex query you have that refuses to “go parallel” on its own.

Evaluate Session