This weeks episode of the SQL Data Partners Podcast is Episode 90 released today.
“I would say that the bigger issue is probably going to be something like snapshot space for your disk”
“When the rubber hits the road I’m still running CheckDB and CheckTable but it’s all about the process behind it”
DBCC CheckDB. It is a simple command, but one that can cause database contention, dba stress, confusing results, dba elation, and everything in between. At one time we will all have to face the results of having a corruption issue and we’re delighted to have Sean McCown with us again to discuss the ins and outs of the issues of this command.
We talk with Sean about how frequent issues we have with maintenance like we often we should run CheckDB on our databases or what happens when I can only check one database during my window. While we don’t end up discussing the command as much, we definitely review all aspects of making sure it can run in ALL environments.
Listen to Learn
- Pros and cons of DBCC CheckDB
- Scenarios to do CheckDB on databases
- Issues with CheckDB
- Running CheckTable
- Minion Tools