Analyzing CXPACKET waits

One of the most common wait types you will see on a SQL Server is the CXPACKET wait type. This wait type is usually at the top of the list when you query the sys.dm_os_wait_stats on servers where you configured the MDOP setting to be anything but ‘1’. CXPACKET waits have everything to do with how your […]