Post reply

Database update statistics takes 11 hours

  • December 3, 2007 at 7:01 am

    #69214

    We have a large database in one file group (one File) that is 250GB in size. The weekly maintenance plan that is scheduled runs the update statistics at 20% sampling. The problem is that it take 11 hours to run. How does one shorten the optimixation (update statistics) scheduled job? It does the entire database and it is used as a Data repository. data gets inserted 24 hours a day but there are no deletes or updates.

    Any help would be appreciated, thanks!

  • December 3, 2007 at 10:43 am

    #756577

    Depending on the requirements

    you could split the statisticsupdate over 2 days.

    Using a cursors to loop through the objects and applying

    UPDATE STATISTICS.

    You could also reduce the sample size.

  • December 7, 2007 at 12:49 pm

    #758205

    Ok I'll try 5% on a 250Gb database.

Viewing 3 posts - 1 through 2 (of 2 total)

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