Several improvements to DBCC CHECKDB to make it run faster

  • Article

SQL Server 2016 has introduced several improvements to DBCC CHECKDB to make it run faster. Here are links to relevant posts that talk about these changes in detail:

  1. CheckScanner using lock free design - https://blogs.msdn.microsoft.com/psssql/2016/02/25/sql-2016-it-just-runs-faster-dbcc-scales-7x-better/
  2. Improvements under Extended Logical Checks - https://blogs.msdn.microsoft.com/psssql/2016/03/01/sql-2016-it-just-runs-faster-dbcc-extended-checks/
  3. MAXDOP option - https://msdn.microsoft.com/en-us/library/ms176064.aspx CHECKDB now introduces a MAXDOP switch that overrides server-wide ‘max degree of parallelism’ configuration setting. This is useful for OLTP environments that typically set MAXDOP 1 server-wide for OLTP workloads which also impacted in longer CHECKDB run time.

 

Ajay Jagannathan (@ajayMSFT)

Principal Program Manager