DBCC Just Runs Faster, Unless You’re Cheap

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.

About the author

James Anderson

I'm a freelance SQL Server DBA in Southampton, UK. Performance tuning code and improving development processes are what I love to do for work. Outside of work, I live to travel to as many places as possible with my wife Sarah.

One thought on “DBCC Just Runs Faster, Unless You’re Cheap”

Leave a Reply

Your email address will not be published. Required fields are marked *

Sign Up

James Anderson SQL Server DBA

Hi, I'm James Anderson. When I'm not blogging about SQL Server, I do this.

The SQL People

DBA Stackexchange Profile