Home Dashboard Directory Help

DBCC CHECKDB entry incorrect in MSDN by Erin Stellato


 as Fixed Help for as Fixed

Sign in
to vote
Type: Bug
ID: 772236
Opened: 11/26/2012 8:16:58 AM
Access Restriction: Public
User(s) can reproduce this bug


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

A very belated thank you for updating the documentation!

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
Sign in to post a workaround.