The SQL Server CXPACKET wait type is one of the most misinterpreted wait stats. The CXPACKET term came from Class Exchange Packet, and in its essence, this can be described as data rows exchanged among two parallel threads that are the part of a single process. One thread is the “producer thread” and another thread …
Интереснейшая статья. Параллелизм- основа повышения производительности сервера. Бездумное его использование может резко снизить производительность.