Post reply

Maintenance Plans

  • August 25, 2006 at 7:44 am

    #61788

    I have a couple of questions regarding maintenance plans.  How offten should I reindex and rebuild statistics?  As it stands now, we run our plans once a month, one day for indexes and the next for statistics.  This was in place before I was hired.  Also we are not running the consistency checks when the plans are run.  My last question, defrag?  Do you use it?  If so, the built in one or thrid party?

    Thanks for looking,

    Bart

  • August 28, 2006 at 8:00 am

    This was removed by the editor as SPAM

  • August 28, 2006 at 8:35 am

    #657103

    Index maintenance depends on your level of activity (insert, update delete). The more it happens, the more often you run this. I've typically run this weekly.

    defrag - Do you mean OS level? I have used both, depending on budget

  • August 29, 2006 at 12:03 pm

    #657327

    Steve,

    Thanks for your reply.  I will have to look into this deeper to see if I have to run my Index maintenace more often.

    Bart

  • August 30, 2006 at 3:00 am

    #657440

    Bart

    Generally speaking, we reindex every week and update statistics once a day.  Reindexing automatically updates statistics, so there is little value in updating once a month the day after the reindex.

    John

  • August 30, 2006 at 7:37 am

    #657511

    John,

    Thanks for the info.  I thought reindexing updated statistics, but wasnt sure.  As you can tell I am no DBA, but I am learning however painful it may be.  We have 4 servers with about 30 DBs each, but one has 90 on it.  I have to get these maintenace plans sorted out. 

    Bart

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

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