Investigating parallelism and the CXPACKET wait type

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.
Presented by Christian Bolton at SQLBits VIII
Tags (no tags)
  • Downloads
  • SpeakerBIO

    Christian Bolton is the Technical Director for Coeo Ltd, a leading provider of SQL Server Managed Support and Consulting in the UK and Europe. He is a Microsoft Certified Architect, Microsoft Certified Master and MVP for SQL Server, and lead author of Professional SQL Server 2012 Internals and Troubleshooting.
  • Video