September 25, 2013 at 2:24 pm
I have two servers each have CTP =5 and MAXDOP = 1. I have same query running on these two servers, cost on each of these is less than 5, so technically it should use all available processors,however on one server even though cost is less than 5 it still uses MAXDOP as 0? Screenshots attached.
September 25, 2013 at 3:21 pm
Do you have resource governor enabled?
September 25, 2013 at 3:25 pm
Degree of parallelism 0 doesn't mean it actually ran in parallel, Are you seeing parallel-specific query operators?
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 25, 2013 at 3:39 pm
ssismaddy (9/25/2013)
Do you have resource governor enabled?
nope
September 25, 2013 at 3:41 pm
GilaMonster (9/25/2013)
Degree of parallelism 0 doesn't mean it actually ran in parallel, Are you seeing parallel-specific query operators?
Can i check that from an execution plan?
September 25, 2013 at 5:20 pm
Execution plan is the place you would look to see that.
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 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply