SqlServerKudos

Welcome!

SqlServerKudos is a place where you can find the latest SQL Server stories and articles to improve your skills and share your opinions.

Enjoy participating in this community and see which others are getting Kudos.

faq »

1
kudos

Kudos

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

published 689 days, 9 hours, 19 minutes ago posted by

sa 698 days, 11 hours, 24 minutes ago

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

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...(read more)

category: News | clicked: 1 | | source: sqlserver-qa.net | show counter code

tags: bpa, configuration server, dbas, i/o, maxdop, rules, SQL Server, SQL Server 2008 R2, Tools

Border color:

Kudos Backcolor:

Kudos Forecolor:

Count Backcolor:

Count Forecolor:

Preview

update reset

SqlServerKudos

Welcome!

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

No comments yet, be the first one to post comment.

Open ID Login

Standard Login

Forgot Password?

Sign up