MAX Degree of Parallelism Option Not working in Resource Governer

• adhiman

  SSC Veteran

  Points: 282

  More actions

  May 29, 2014 at 11:52 am

  #286023

  I am running a query on SQL 2012 Server with the Resource governer setup for my account to have Max DOP option set to 1.

  The query still runs in about 1 minute and the execution plan still considers parallelism.

  When I explicitly mention the OPTION (MAXDOP 1) , the query runs in 6 seconds.

  Can you please help in understanding why this might be happening?

  How can i tell by querying DMV's whether my query is using parallelism or not?

  I know there was some bug in 2008 regarding this but i believe it is fixed in SQL 2012.

• sgmunson

  SSC Guru

  Points: 110588

  More actions

  May 29, 2014 at 12:02 pm

  #1717488

  This should be posted in the 2012 forum, not the 2008 one.

  Steve?(aka sgmunson)?:) 🙂 :)?
  Health & Nutrition
  Rent Servers for Income (picks and shovels strategy)