Post reply

DBCC commands

  • July 10, 2008 at 4:09 am

    #123088

    What is the main purpose of DBCC CHECKDB and DBCC CHECKALLOC

    ...in simple terms pls..thanks

  • July 10, 2008 at 4:16 am

    #840713

    It checks the integrity of your database to ensure you have no corruption present.

    CheckDB includes all the checks done by checkAlloc, so it's not necessary to run both.

    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

  • July 10, 2008 at 4:47 am

    #840719

    thanks for the quick reply

  • July 10, 2008 at 7:47 am

    #840821

    Adding to it: It shouldnt be RUN Frequently, I would recommend once a Week.

    Maninder
    www.dbanation.com

  • July 10, 2008 at 11:05 pm

    #841232

    Hi,

    CheckDB is the superset of checkAlloc, so if you are running CheckDB, its not necessary to run checkAlloc.

    thanks


    nkgupta

  • July 11, 2008 at 12:09 am

    #841253

    Running it frequently..does it mean that we need to run these commands say very week on all the databases? doesnt it affect the overhead performance? if we need to run..then what time is advisable?..and can any one pls suggest some examples too..thanks..

  • July 11, 2008 at 12:15 am

    #841255

    They are extremely resource intensive. You should not run them when you have users accessin the DB. If you have downtime over a weekend, run the checkdb then

    You should (imho) run them once a week or once a fortnight. If you get corruption in the DB, it's very, very important to find it quickly and know when the database was corruption free for the purposes of selecting a recovery strategy.

    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

  • July 11, 2008 at 10:40 am

    #841701

    thank you! can you please provide me with some examples , as to how the results would look, if any error in the database was spotted...after running these DBCC commands? and what would be the next steps.? thanks

  • July 11, 2008 at 12:11 pm

    #841747

    DBCC will generate a report for you whether having issue or not.

  • July 11, 2008 at 2:21 pm

    #841809

    There are examples of how to use it in Books Online.

    CheckDB generates a lot of info messages as it runs. If it finds any errors it will tell you. As for what you do if it finds one, well, that depends on what kind of error it finds.

    If you want a lot of reading on fixing the kind of problems that CheckDB finds, read through Paul's blog[/url]

    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

  • July 12, 2008 at 3:02 am

    #841960

    Thanks alot!

  • October 16, 2008 at 10:52 am

    #885978

    I am trying to understand the need to run DBCC checkDB. We have set up maintenance plan to reindex and check the integrity of DB weekly. Every thing works fine.

    Do we still need to run DBCC check DB weekly? What could we find if we run our maintenance plan regularly

  • October 16, 2008 at 11:30 am

    #886004

    The maint plan that checks ingegrity runs checkDB. There's no need for a manual job if the maint plan's doing it

    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

Viewing 13 posts - 1 through 12 (of 12 total)

You must be logged in to reply to this topic. Login to reply