Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Is DBCC CHECKDB an appropriate weekly check for a 365x24x7 availability db? Expand / Collapse
Author
Message
Posted Monday, March 25, 2013 5:08 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, August 20, 2014 6:39 AM
Points: 68, Visits: 153
We have a db that has a mission critical website sitting on top of it. We check it weekly with a DBCC CHECKDB command, which takes 1 to 2.5 minutes to run. Are web users likely to see issues during that time? If so, is there a better way to do a weekly health check on it?
Post #1434827
Posted Monday, March 25, 2013 5:29 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 8:40 AM
Points: 5,221, Visits: 5,116
Whats your RTO and RPO for the database? If its mission critical and DBCC CHECKDB only takes 1 - 2.5 minutes to run, I would run it every day not weekly. The only impact to the users would be while the snapshot is being created that DBCC CHECKDB runs on, so will be very minimal.



Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1434836
Posted Monday, March 25, 2013 6:17 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 6:05 AM
Points: 40,258, Visits: 36,681
CheckDB is an online operation. Users may note slow down, but that's all.

Better question, if your database becomes corrupt, how soon do you want to find out about it and how long do you retain your backups?
If you do find corruption, restore from backup should always be an option and that means doing integrity checks often enough that restore from a clean backup is always possible



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1434857
Posted Monday, March 25, 2013 6:19 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 6:05 AM
Points: 40,258, Visits: 36,681
anthony.green (3/25/2013)
The only impact to the users would be while the snapshot is being created that DBCC CHECKDB runs on, so will be very minimal.


The creation of the snapshot won't affect any users. The impact from checkDB is the process of running the checks after the snapshot has been created, because of the IO and CPU load from CheckDB



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1434861
Posted Thursday, March 28, 2013 3:07 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, August 20, 2014 6:39 AM
Points: 68, Visits: 153
Anthony and Gail,

Thanks very much for our comments. You have reassured me.

Best wishes
Mark
Post #1436323
Posted Thursday, March 28, 2013 3:32 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 9:07 AM
Points: 231, Visits: 754
I restore backup another server and then ı make checkdb
Post #1436332
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse