SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

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.

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

The Database Avenger

My name is James Anderson and I am a SQL Server production DBA in the south of the UK. I have been working with databases since 2008. The first RDBMS I worked on was Paradox and I never want to see it again. I quickly moved to using T-SQL in SQL Server 2005. I have worked on every version of the product since. I enjoy query tuning and server optimisation. I detest transactional replication.

Comments

Leave a comment on the original post [thedatabaseavenger.com, opens in a new window]

Loading comments...