September 23, 2008 at 10:37 pm
Hi DBA,
I have some question, anyone can help me to my problem,
I have scheduled the sp_updatestats every 2 days during off peak hours around 11:15pm, but after the completed process, my job running around 12:30am, it took long duration, but if the sp_updatestats is not runing is ok to run.
If I scheduled the sp_updatestats on weekends every 7 days, did it will cause any impact or slowness to database?
Anyone can help me please...
Thanks
September 23, 2008 at 11:16 pm
Hi
It all depends on the size of your database and the amount of data that gets inserted/deleted/modified. If size of db is huge and the data modifications is also huge update stats can take a long time.
Another reason for slowness could be other processes that are running during that time like backups etc. Check that out.
If your data modifications are not huge you could schedule your update stats after a larger interval i.e every 7 days,15 days etc.
"Keep Trying"
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply