November 30, 2020 at 12:02 pm
Hi
using MS SQL maintenance plan to update statistic with full scan. The plan running over 2 days but still running. Try to restart DB server but the job auto resume. How can I kill all statistic update or estimate the complete time ?
November 30, 2020 at 1:14 pm
I'd suggest removing the job entirely. However, probably, what you're seeing isn't the job restarting. It's probably rolling back since you killed it. You'll need to just let that finish. There's no way to stop rollbacks as they're part of the recovery process. Also, no real way for certain to know how much longer it will be running. Probably, about as long to roll it back as it took to run it.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply