DBCC CHECKDB Slow on SQL Server 2019 Standard Edition

Question

DBCC CHECKDB Slow on SQL Server 2019 Standard compared to that on same DB in SQL server 2012 Enterprise.

Same number of virtual processes on both servers (16) , but on the 2019 Server there are 4 sockets and on the 2012 Server there are 2 Sockets.

MAXDOP on both servers is 4.

Answer 1

Hi,

Let's start from the most relevant and common point

DBCC CHECKDB Slow on SQL Server 2019 Standard compared to that on same DB in SQL server 2012 Enterprise.

In Standard Edition, CHECKDB is single-threaded, which directly lead to such behavior.

Using Enterprise Edition, CHECKDB respects the maximum degree of parallelism.

----- More information -----

This information is documented but very poorly and not well in my opinion

https://learn.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-checkdb-transact-sql?view=sql-server-ver15#checking-objects-in-parallel

If you will check the official documentation regarding DBCC CHECKDB, then you will notice that there is not explicitly information about the fact that standard edition does not support Parallel consistency check.

The only information it provide for some reason, is only in the comment: This feature is not available in every edition of SQL Server.

But if you go to the mentioned document about the components of the different editions of SQL Server then the information is explicitly documented in one word: no

https://learn.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2016?view=sql-server-ver15#RDBMSM

Answer 2

Hi @eyal golombek ,

Welcome to Microsoft Q&A forum.

Agree with pituach. In SQL server Standard Edition, CHECKDB is single-threaded. SQL server Enterprise Edition has parallel corruption checking.

If you want to run DBCC CheckDB faster, suggest you reading below blog.

3 Ways to Run DBCC CHECKDB Faster

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".