SQL Server Performance

SQL Server 2008 R2 BPA and MAXDOP rules - Database Engine - degree of parallelism is not set to recommended value

Discussion in 'Other SQL Server Blogs around the Web' started by Anonymous, Jun 25, 2010.

  1. Anonymous New Member

    In continuation to my Leverage Query and Index performance with MAXDOP/Max Degree of Parallelism option in SQL Server post on MAXDOP settings, I had an interesting rules to review when SQL Server 2008 R2 BPA ( download ) is executed. By default SQL 2008 R2 BPA has an embedded rule to detect the conditions of appropriate value for 'max degree of parallelism' option, and it is not configured in conjunction with the number of CPU's within a NUMA node as well as the Resource Governor (RG) workload configuration...(<a href="http://sqlserver-qa.net/blogs/sql2008/archive/2010/06/25/9147.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=9147" width="1" height="1">

Share This Page