SQL 2005 WAIT CXPACKET

昨天晚上sp_SinosoftData_prpJ_Inc過程一直沒有執行完成，我檢視了活動監視器和SQL SERVER PROFILER 發現跑過程的程式一直處於掛起狀態如上圖，但是不是被堵塞，

等待事件為CXPACKET。查詢了一些資料描述如下：

Wait type - CXPACKET 

It means SQL Query is involved in parallel query execution. This waittype indicates that the SPID is waiting on a parallel process to complete or start.

CXPACKET: Occurs when trying to synchronize the query processor exchange iterator. You may consider lowering the degree of parallelism if contention on this wait type becomes a problem.

 

我修改了設定cost threshold for parallelism和max degree of parallelism，現在已經可以正常執行了。