adhiman (5/29/2014)

---

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.