Wait Types – CXPACKET (54 minutes)

I show you a query that produces CXPACKET waits, measure it with sp_BlitzFirst (formerly sp_AskBrent), and explain what the cryptic letters in CXPACKET stand for. Then we talk about how to fix it long term, and why you can’t make it go away with settings alone. Demo Code If you want to follow along with…

To access this incredible, amazing content, you gotta get Fundamentals of Server Tuning with Wait Stats or Recorded Class Season Pass, or log in if you already shelled out the cash.