Dbcc checkdb how long it takes

Sad but true. Dave Drager Dave Drager 8, 27 27 silver badges 45 45 bronze badges. I've personally watched it run for hours on very large databases. Walk away and get your mind off it for a little bit. Trust me on this. This answer obviously does not come close to Paul's awesome answer to your specific question. Sean Earp Sean Earp 7, 3 3 gold badges 33 33 silver badges 38 38 bronze badges. Sign up or log in Sign up using Google.

Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Podcast Explaining the semiconductor shortage, and how it might end. Does ES6 make JavaScript frameworks obsolete? Featured on Meta. Now live: A fully responsive profile. Related 2. Hot Network Questions. Question feed. You can receive help directly from the article author. Sign up for a free trial to get started.

Start Free Trial. Log In. Web Dev. Published: Updated: Or do you maybe wanna find out as soon as possible and fail outta there before it hits a clustered index and really ruins your day? Klaus — yep, that too! Which is the total time that DBCC took to run? Howdy sir.

I just wanted to be sure. Just to be sure because the written work frequently sucks when trying to determine intent , no jabs where intended in my original post or my previous one about this fine article. Please pass the coffee! Your email address will not be published.

Don't subscribe All Replies to my comments Notify me of followup comments via e-mail. You can also subscribe without commenting. Post Comment. Want to advertise here and reach my savvy readers?

Performance tweak 1: run it across more cores. Also, there are at about a dozen other DBCC's executing at the same time on databases ranging in size from 5 Gb to 30 Gb on this same server during our nightkly maintenance. J Bagwell. It also depends on what else is running and whether or not the DBCC finds any errors.

If our DBCC runs for more than an hour, we can almost guarantee that it is going to return consistency errors. In this case, it can sometimes run for 4 or 5 hours before returning those errors. You must be logged in to reply to this topic.