tech at work


Why does SQL DBCC use only one CPU core

EDIT: The author of the previously linked article sent me a comment to either remove the quotation or my entire post. I just intended to share this important information by linking to the original article. Now I removed the quotation and the link - so please enjoy my own explanation for this issue 😉

Found "somewhere" on the internet: In SQL Standard Edition CHECKDB just uses one CPU core as it's doing the checks single-threaded. If you use SQL Enterprise Edition, CHECKDB is behaving like configured by the maximum degree of parallelism setting in the instance.

If you are interested in the original article you can find it on the internet by yourself

Filed under: Windows Leave comment
Comments (2) Trackbacks (0)
  1. […]You have linked to my blog, and quoted text directly from my blog. Can you either please quote the text correctly, and attribute it to my post, or remove this post entirely? Thank you. […]

Leave a comment

No trackbacks yet.