sp_updatestats

  • Hello,

    When runnig sp_updatestats every night / every week, will this impact (decrease) the performance on the database server? Currently no maintenance window can be defined because the DB is used 24h/24h 7d/7d.

    The reason why I ask this is because I see that al lot of stats are not up to date. (Auto update stats = ON) and I want to implement a job that runs every day or week that will perform a sp_updatestats.

    Thx in advance,

    David

  • You're database needs up time 24x7, but is there a time that the system usage is lowwer than others? A healthy database does need some maintenance, and if some of your statistics are out of date as you say, then the database will try to update them at query time which could cause performance problems also.

    How much your data grows and/or changes over a given day will probably be the driving factor of if you should schedule statistics recalculation. If the data is relatively static with little growth or change then statistics recalculation won't help much. If there is lots of growth and/or change then you might want to consider it.

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

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