Steve Stedman 0:15 So Derrick, one of the things we run into is customers who are a little bit resistant to running CheckDB as frequently as maybe we think they should normally. And I guess, I’m just curious, what are your thoughts on how frequent? Or how important it is to run CheckDB frequently? Derrick Bovenkamp 0:51 Yeah, that’s, that’s …
When running DBCC CHECKDB, you will often times get screens of information back stating that the database is all okay, and that it checked every table. This can be quite tedious when you are trying to search through thousands of lines of output to see where the real error is. You can use the WITH NO_INFOMSGS when running checkdb to …
One of the common CheckDB errors that I see is the Message 824, level 24. This is something that I regularly work to repair for customers with great success. DBCC results for ‘YourDatabaseName’. CHECKDB found 0 allocation errors and 0 consistency errors in database ‘ YourDatabaseName’. Msg 824, Level 24, State 2, Line 1 SQL Server detected a logical …
Occasionally you may want to run DBCC CheckDB against all of the databases on your SQL Server. Hopefully you have a job to run checkdB regularly, but in case you just want to check to confirm that you have no corruption on all of your databases right now you can use this script. Once you run the script copy …
Quick script to run DBCC CheckDB for all of your databases Read more »
You have a DBCC CHECKDB script running, something like the following, and it may take several hours to run to confirm if there is any corruption in your SQL Server Database. Then someone asks you the age old question… When will it be done? You look at the window running the command and you can see how long it …
DBCC CheckDB or CheckTable – Find percent complete Read more »
From time to time I get asked about checkDB, and there are many solutions out there, but I have one that I generally use that is very simple and does the job. The script below created a stored procedure in the DBHealthHistory database that can be used to check as many databases as you can get through in a specific …
This weeks episode of the is Episode 90 released today. Episode Quote “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” Overview DBCC CheckDB. It is a simple command, but …
Special thanks to my friend Theresa Iserman for introducing me to Jos de Bruijn the Senior Program Manager for the In Memory OLTP (Hekaton) project to help get my questions answered at PASS Summit. So, the Hekaton – In Memory OLTP tables are perhaps one of the most amazing performance improvements to SQL OLTP in a long time. The way …
DBCC CheckDB and CheckTable doesn’t check In-Memory OLTP. Read more »
So you are checking your database with DBCC CheckDB and of course if you are like me you use the WITH NO_INFOMSGS parameter. But it turns out that CheckDB is taking longer to run that you expected, and you want to check and see what table is currently being checked. Here is a quick SQL Script that I use to …
If you use the SQL Server maintenance plans to run DBCC Check DB, you are not allowed to include TempDB in your DBCC CheckDB sequence. For a while I was using maintenance plans, and ending up adding a separate job step to run TSQL to just check TempDB. Rather than using two different steps, the regular maintenance plan, and a …