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.