Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

MAXDOP uses different settings? Expand / Collapse
Author
Message
Posted Wednesday, September 25, 2013 2:24 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, April 01, 2014 3:44 PM
Points: 1,266, Visits: 2,912

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.


  Post Attachments 
MAXDOP_1.jpg (6 views, 61.58 KB)
MAXDOP_0.jpg (5 views, 49.57 KB)
Post #1498587
Posted Wednesday, September 25, 2013 3:21 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 1:20 PM
Points: 836, Visits: 2,080
Do you have resource governor enabled?
Post #1498602
Posted Wednesday, September 25, 2013 3:25 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 12:20 PM
Points: 41,529, Visits: 34,445
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 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1498605
Posted Wednesday, September 25, 2013 3:39 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, April 01, 2014 3:44 PM
Points: 1,266, Visits: 2,912
ssismaddy (9/25/2013)
Do you have resource governor enabled?


nope
Post #1498611
Posted Wednesday, September 25, 2013 3:41 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, April 01, 2014 3:44 PM
Points: 1,266, Visits: 2,912
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?
Post #1498612
Posted Wednesday, September 25, 2013 5:20 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 12:20 PM
Points: 41,529, Visits: 34,445
Execution plan is the place you would look to see that.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1498630
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse