Home Forums SQL Server 2008 SQL Server 2008 - General Is DBCC CHECKDB an appropriate weekly check for a 365x24x7 availability db? RE: Is DBCC CHECKDB an appropriate weekly check for a 365x24x7 availability db?

  • March 25, 2013 at 6:19 am

    #1600262

    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, MVP, M.Sc (Comp Sci)
    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