Search

DBCC CHECKDB entry incorrect in MSDN by Erin Stellato

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)
0
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.

Details (expand)

Product Language

English

Version

SQL Server 2012 - Standard Edition

Category

Documentation

Operating System

Not Applicable

Operating System Language

Not Applicable

Steps to Reproduce

Execute CHECKDB against Standard Edition, note that it will only run single-threaded.

Actual Results

CHECKDB performs correctly according to the source code. However, the documentation is incorrect.

Expected Results

Please update the documentation to state that CHECKDB in Standard Edition does not utilize parallel processing.

Platform

 

Virtualization

 
File Attachments
0 attachments
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.