Regular Session

Parallel Query Execution [DBA-404]

Paul White
75 minutes
Enterprise Database Administration & Deployment
400
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.
3 years' experience writing complex T-SQL queries.

cage-aids
cage-aids
cage-aids
cage-aids