DBCC CHECKDB entry incorrect in MSDN - by Erin Stellato

Status : 

  Fixed<br /><br />
		This item has been fixed in the current or upcoming version of this product.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


2
0
Sign in
to vote
ID 772236 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 11/26/2012 8:16:58 AM
Access Restriction Public

Description

The DBCC CHECKDB entry (http://msdn.microsoft.com/en-us/library/ms176064.aspx) states that SQL Server always performs parallel checks (excerpt below):

Checking Objects in Parallel

By default, DBCC CHECKDB performs parallel checking of objects. The degree of parallelism is automatically determined by the query processor. The maximum degree of parallelism is configured just like parallel queries. To restrict the maximum number of processors available for DBCC checking, use sp_configure. For more information, see Configure the max degree of parallelism Server Configuration Option. Parallel checking can be disabled by using trace flag 2528. For more information, see Trace Flags (Transact-SQL).

This is incorrect.  In Standard Edition (and presumably anything that's not Enterprise), CHECKDB is a single-threaded operation.  Only Enterprise Edition performs parallel checking.

Sign in to post a comment.
Posted by Erin Stellato on 2/7/2013 at 6:50 PM
Gail,

A very belated thank you for updating the documentation!

Erin
Posted by Microsoft on 12/5/2012 at 11:37 AM
The updated topic has now been published. Please see http://msdn.microsoft.com/en-us/library/ms176064

Gail Erickson
SQL Server Documentation Team
Posted by Microsoft on 11/28/2012 at 2:19 PM
Hi Erin,
Thanks for reporting this discrepancy. You are correct, parallel consistency checks are limited to the Enterprise edition. I will update the topic this week and it will be published in early December.

Kind regards,
Gail Erickson
SQL Server Documentation Team