Another Reason To Install Service Pack 1 CU3 on SQL Server 2008

Microsoft has a new KB article describing a problem where the MAXDOP setting that you specify (whether at the instance level with sp_configure or at the query level) is ignored by SQL Server 2008, unless you set it to 1.

The MAXDOP setting controls whether and how SQL Server may decide to parallelize a query by running it on multiple processor cores. If you have an OLTP workload, it is pretty well accepted common wisdom that you should set MAXDOP to 1 at the instance level, so that SQL Server will not parallelize queries (unless you override it at the query level with a query hint such as OPTION MAXDOP (1). I have had very good performance results at NewsGator running with MAXDOP = 1 at the instance level.

People who have non-OLTP workloads usually run with MAXDOP set to a higher number, since long running report type queries can often benefit from being parallelized. They are the ones most affected by this bug, which is corrected in SQL Server 2008 SP1 CU3.

This entry was posted in SQL Server 2008. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s