The CXPACKET term came from Class Exchange Packet, 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 is the “consumer thread”. This wait type is directly related to parallelism and it occurs in SQL Server whenever SQL Server executes a query using parallel plan.
You may consider lowering the degree of parallelism if contention on this wait type becomes a problem.
For more details please refer.
You may consider lowering the degree of parallelism if contention on this wait type becomes a problem.
For more details please refer.
No comments:
Post a Comment