昨天晚上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,现在已经可以正常运行了。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7728585/viewspace-689501/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/7728585/viewspace-689501/