SQLBits 2011

Investigating parallelism and the CXPACKET wait type

In this session you'll learn how SQL Server chooses parallel operations, how to investigate what's going on when you see the CXPACKET wait type, and whether your parallel query is running as efficiently as it could be.
In this session you'll learn how and why SQL Server chooses parallel operations, how to investigate what's going on when you see the CXPACKET wait type, and whether your parallel query is running as efficiently as it could be.