September 23, 2008 at 9:09 am
I have an execution plan and pretty much understand how to tune basic stuff; however, I am curious about a type of execution plan icon (does not matter which one) that has two arrows in a circle on the bottom right half of the icons. Does anyone know what these arrows represent?
Thanks,
Bobby Johnson
September 23, 2008 at 9:14 am
Possibly that it's running as a parallel operation. If you could attach a pic of said operator, I can tell you for sure.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 23, 2008 at 10:52 am
That was it. I have OPTION (MAXDOP 4) after each query and changed it to OPTION (MAXDOP 1) and the lines went away. Thanks!
September 23, 2008 at 11:35 am
Do you have a reason for wanting the queries to not run paralleled?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply