• dax.latchford (7/2/2014)


    Hi - Many thanks for the reply. Is it best to run update statistics out of hours when there is no user activity and after a backup?

    Regards

    Dax

    Generally - that would be the ideal solution. With that said, SQL Server will update statistics automatically as needed throughout the day - but that could in some circumstances cause even more issues. When SQL Server performs an auto update of statistics - it will use the default sampling rate and that may cause a less than optimal execution plan to be generated.

    Whether or not this has any affect will be determined by the index/column in question.

    All this comes down to is - in general, yes - updating statistics after hours is the best, but if you have issues on specific tables you may want to consider updating those statistics more often.

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs