Several improvements to DBCC CHECKDB to make it run faster
Published Mar 23 2019 02:17 PM 608 Views
First published on MSDN on Mar 01, 2016

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 -
  2. Improvements under Extended Logical Checks -
  3. MAXDOP option - 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

Version history
Last update:
‎Mar 23 2019 02:17 PM
Updated by: