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