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.
| 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,GangadharaThanks,Gangadhara MSSQL Developer and DBA |
|
|
bandi
Master Smack Fu Yak Hacker
2242 Posts |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
|
|
|
|
|
SQL server 2008 R2 - CXpacket wait type