The CSS SQL Server Engineers have released a post showing that consistency checks using DBCC CHECKDB is faster and scales better in SQL Server 2016.

This is great news for all of us, especially if you are struggling to get all of your maintenance done within your allotted maintenance window.

One thing to note is that the graph in that post (test database was 1TB in size) shows that things could actually be slower if you are running with MAXDOP 4. This could be concerning to the people who are trying to keep licensing costs down by running on as few cores as possible. People do this because SQL Server is licensed per core.

This post is just a quick reaction to reading the post mentioned above so I haven’t done any testing yet but this could cause companies to require even longer maintenance windows.

Let me know what you think below.

The post DBCC Just Runs Faster, Unless You’re Cheap appeared first on The Database Avenger.