SQL Server DBA

Vocabulary

Question

What does CXPACKET indicate?

Answer

A parallel-query coordination wait in which a worker waits at an exchange operator for related workers. Production impact. Sustained CXPACKET can indicate parallel-plan skew, long-running parallel work, or CPU pressure; interpret it with query plans and runnable-task pressure.

This is 25 of 25 free samples for SQL Server DBA.

More SQL Server DBA topic samples