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 |
|
DBADave
Constraint Violating Yak Guru
366 Posts |
 Posted - 2008-09-18 : 13:22:39
|
| We have a stored procedure that produces different results when invoked from ADO vs. directly from Management Studio. Through ADO the query never completes, but through Management Studio it completes in a few seconds. Showplan XML reveals the exact plan being used for each execution. It also shows parallelism is being used when performing the final SELECT statement. If modified by adding OPTION (MAXDOP 1), the ADO process completes in a few seconds. The question is why does parallelism appear to cause the ADO-related process to not complete, yet execution through Management Studio is not a problem?Thanks, Dave |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-18 : 13:35:41
|
| http://www.sqlservercentral.com/articles/Configuring/managingmaxdegreeofparallelism/1029/ |
 |
|
|
|
|
|
Parallelism & Slow Performance - Why?