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 …
Источник: Troubleshooting the CXPACKET wait type in SQL Server – SQL Shack – articles about database auditing, server performance, data recovery, and more
Интереснейшая статья. Параллелизм- основа повышения производительности сервера. Бездумное его использование может резко снизить производительность.
