1. 首页
  2. IT资讯

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 parallelismmax degree of parallelism,现在已经可以正常运行了。

 

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7728585/viewspace-689501/,如需转载,请注明出处,否则将追究法律责任。

主题测试文章,只做测试使用。发布者:深沉的少年,转转请注明出处:http://www.cxybcw.com/183592.html

联系我们

13687733322

在线咨询:点击这里给我发消息

邮件:1877088071@qq.com

工作时间:周一至周五,9:30-18:30,节假日休息

QR code