Post reply

schduled task for update statistics and Reindex on live servers

  • November 13, 2008 at 10:12 pm

    #196351

    I want to create schduled task for update statistics and Reindex on live servers, i am confuse to make time schdule for bith job?..

    so,what should be time schdule for both job?

    I have make time schdule of update stats on weekly basis and

    for Reindex on monthly basis ? so is it ok?

    Please give me ur suggestion for these jobs ans schdule?

    _____________________________________________________________________________________________________________
    Paresh Prajapati
    ➡ +919924626601
    http://paresh-sqldba.blogspot.com/[/url]
    LinkedIn | Tweet Me | FaceBook | Brijj

  • November 13, 2008 at 10:49 pm

    #898404

    [font="Verdana"]It depends on the frequency of DML statements happening in the database. If this is a busy OLTP server then you can do it twice a week else your schedule looks good.[/font]

    Regards..Vidhya Sagar
    SQL-Articles

  • November 14, 2008 at 12:55 am

    #898435

    Depends how fast the indexes fragment. If you have an index where the fragmentation increases about 2% a month, then reindexing weekly is too often. If you have an index that goes from 0 to 99.9% fragmented in 6 hours, then weekly is not enough.

    Use the sys.dm_db_index_physical_stats to see fragmentation.

    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 3 posts - 1 through 2 (of 2 total)

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