Several improvements to DBCC CHECKDB to make it run faster
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:
- CheckScanner using lock free design - https://blogs.msdn.microsoft.com/psssql/2016/02/25/sql-2016-it-just-runs-faster-dbcc-scales-7x-better/
- Improvements under Extended Logical Checks - https://blogs.msdn.microsoft.com/psssql/2016/03/01/sql-2016-it-just-runs-faster-dbcc-extended-checks/
- 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