Post reply

optimization and integrity checks

  • December 16, 2004 at 8:32 am

    #361716

    HI All,

    I wanted to get some opinions on the running of the optimization and integrity checks of the db maintenance plan. my question is, are these 2 parts of the plan recommended to be ran nightly, weekly, etc? it appears when i run the optimization and integrity checks, my tlog grows very large and was just wondering if these jobs need to be ran nightly.

    thanks so much !

    Juanita

     

  • December 16, 2004 at 12:44 pm

    #534230

    It depends on your situation.  If you're loading thousands or rows into your tables every night, you certainly want to update statistics.  You might even consider dropping indexes before the load and creating them after.  But if your tables see very few inserts and updates, you probably don't need to update statistics as often.

    As far as DBCCs go, it depends on your maintenance window and the amount of risk you are willing to accept.  If you have time to perform checks every night, you probably want to.  Otherwise, several days may pass before you catch the problem.

    When I can't afford to run DBCCs nightly on a production database, I'll sometimes restore production to a test enviornment every night and perform DBCCs there.

  • December 16, 2004 at 1:37 pm

    #534236

    Thanks so much !!!

  • December 16, 2004 at 2:59 pm

    #534250

    I would also suggest that if the data is slowly changing with few updates then those tasks may not buy you all that much but data that is quickly changing will bennifit more. Weigh that in you decision especially if you have a limited window to do what you can.

  • December 16, 2004 at 3:07 pm

    #534253

    THANKS !!!

Viewing 5 posts - 1 through 4 (of 4 total)

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