Ever receive a late afternoon call just as you are unplugging your laptop to head home from an angry developer complaining about latency in his application trying to return data from your server? I know, I know, your first thought is “why did I answer that phone?” He claims that it is not his code and must be the database server. You hold your sarcastic comments, log into your server, and run sys.dm_os_wait_stats DMV only to find the wait stats for CXPacket to be through the roof. CXPacket what?
So what exactly are CXPackets? Read more here.