SQL SERVER开启CPU并行导致的死锁案例

       抓取到死锁信息（抓取方式参见https://vip.kingdee.com/article/81399817955699456），

    发现4个节点的等待资源类型为e_waitPipeNewRow，查阅微软官方文档，发现下面信说明： 

Parallel query resource owner:

• exchangeEvent id={Port|Pipe}<hex-address> WaitType=<exchange-wait-type> nodeId=<exchange-node-id>

Exchange-wait-type:

• e_waitNone

• e_waitPipeNewRow

• e_waitPipeGetRow

• e_waitSynchronizeConsumerOpen

• e_waitPortOpen

• e_waitPortClose

• e_waitRange

    说明等待的资源类型是跟并行查询相关。该等待类型表示线程正在等待传递数