May 28, 2008 at 10:21 am
I have a server that I have been running a maintenance plan on for several months to update statistics. This runs at 3:00 am and was consistently running for around 3 minutes. Now, it is taking 10-11 hours to complete. I don't know of anything that has changed on the databases.
Has anyone else had any issues with the 'update statistics' running so long? What happens if I kill that process - will it corrupt anything? I will stop the job in the future until I can find the problem, but for today no one is able to get any work done while this is running???
Any suggestions on what to check?
Thanks,
Kim Talley
May 28, 2008 at 10:34 am
Look at sp_who2, and dbcc inputbuffer to see what work is being done. I might profile as well and see if anything is happening or if the connection is just stuck.
You might need to kill it or even reboot to clear things up.
May 28, 2008 at 10:44 am
Would it make a difference if the databases on this server were on compatibility level 80?
May 28, 2008 at 11:09 am
no, i only run index rebuilds so i don't have to worry about updating statistics
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply