Home Dashboard Directory Help
Search

DBCC CHECKDB entry incorrect in MSDN by Erin Stellato


Status: 

Closed
 as Fixed Help for as Fixed


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

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.

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