What is the CXPACKET Wait Type, and How Do You Reduce It?
120 Comments
When you query sys.dm_os_wait_stats, or check your waits with sp_Blitz® or sp_BlitzFirst®, one of your biggest wait types is probably CXPACKET. Let’s talk about what’s really going on. Our SQL Server Stand-In: a Class. Who wants to help me scan the sales table? Pretend that you’re a schoolteacher in a classroom with a couple dozen students.…
Read More