The tag has no wiki summary.

learn more… | top users | synonyms

1
vote
2answers
136 views

SQL Server : CheckDB runs fast enough on one database, agonizingly slow on another

This one's for you, Paul! :-) I have a customer which has two databases for two of his office locations. Both are roughly the same size (around 10 GB), both are hosted at the same professional ...
1
vote
1answer
1k views

SqlServer 2008R2 sp1 CHECKDB crashes when spatial index present

We've been having an issue with DBCC CHECKDB crashing with an access violation (null pointer deference) on Sql Server 2008R2 when spatial indexes are present. It is repeatable with DBCC CHECKDB WITH ...
1
vote
2answers
564 views

is there a GOTCHA - DBCC CHECKDB ('DBNAME', NOINDEX)?

I am turning on DBCC CHECKDB in our OLTP environment (SQL 2005,2008). System overhead is a very visible thing on our serversso I want them to be as efficient as it makes sense for them to be. HENCE - ...
0
votes
2answers
231 views

Dividing DBCC CHECKDB over several days

I'm working on implementing Paul Randal's method of manually spreading DBCC CHECKDB over several days from his excellent article CHECKDB From Every Angle: Consistency Checking Options for a VLDB. In ...
5
votes
4answers
3k views

Should I run DBCC checkdb before full backups? Or after?

We have a mix of SQL 2000, 2005, and 2008 servers, and we've always run a DBCC CHECKDB nightly just before the full backups, under the theory that you want to make sure the DB is in good shape before ...
1
vote
2answers
2k views

Killing DBCC CheckDB when storage blips

The controllers on one of my cluster's SAN's are periodically restarting themselves. Apparently it can be fixed by a firmware update, but until we can apply the update in a few days, I have to live ...
2
votes
2answers
203 views

SQL server 2005 Checkdb - no room for snapshot files

I have a 2Tb+ SAP database with 8 datafiles, the first files have grown to fill the available disk space on our HP EVA5000, and the growth is now on the new files. We upgraded SQL from SQL server 2000 ...
3
votes
3answers
3k views

How long should I expect CheckDB with REPAIR_ALLOW_DATA_LOSS to run

I am running CheckDB with REPAIR_ALLOW_DATA_LOSS on a Shairpoint search DB that is 47mb It has been running for > 30min. Is that normal? How long should it take?