Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 SQL server 2008 R2 - CXpacket wait type

Author  Topic 

gangadhara.ms
Aged Yak Warrior

549 Posts

Posted - 2014-02-18 : 20:11:09
Hi,

I am running one stored procedure in which it contains union and inserting into another table which is referred in joining condition also. Its runnign morethan 5 hours but not completed yet but it useally tooks only 4 minutes earlier.

But its taking too long time to run and when i monitor this in activity monitor cxpacket wait type and wait resource of exchange event ID=pipe362 it shows.

Please suggest how can i fine tune this.

Regards,
Gangadhara

Thanks,
Gangadhara MS
SQL Developer and DBA

bandi
Master Smack Fu Yak Hacker

2242 Posts

Posted - 2014-02-19 : 01:04:39
Refer
http://blog.sqlauthority.com/2011/02/06/sql-server-cxpacket-parallelism-usual-solution-wait-type-day-6-of-28/

--
Chandu
Go to Top of Page

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2014-02-20 : 01:49:34
Some troubleshooting approaches on cxpacket - http://www.sqlserver-dba.com/2011/02/waitstats-cxpacket-wait-type-and-how-to-reduce-it-.html

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page
   

- Advertisement -