http://blogs.msdn.com/b/psssql/archive/2011/02/03/resource-governor-and-maxdop-parallel-plan-generation.aspxI had an interesting conversation with some other support engineers and a customer as it relates to the MAXDOP setting in the workload group. Inquiry: The customer set the MAXDOP=1 for the workload group but when looking at the showplan the parallel operatorsen-USTelligent Evolution Platform Developer Build (Build: 5.6.50428.7875)http://blogs.msdn.com/b/psssql/archive/2011/02/03/resource-governor-and-maxdop-parallel-plan-generation.aspx#10249860Wed, 21 Dec 2011 07:11:09 GMT91d46819-8472-40ad-a661-2c78acb4018c:10249860Varun_SQL<p>Great observation and explanation !</p> <p>I just have one doubt, when you say &quot;if you change the max degree of parallism setting via sp_configure as soon as you issue the reconfigure action the query cache is emptied&quot;. Does that empties entite query cache all plans are gone) ?</p> <p>Varun Dhawan | Database Architect</p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10249860" width="1" height="1">