czwartek, 22 listopada 2012

Slow death .. of SPID

Just killed long-time SQL process..

kill 57

And now I have to wait till it die for good..

Message says:

SPID 57: transaction rollback in progress. Estimated rollback completion: 84%. Estimated time remaining: 113 seconds.

Conclusion: killing process makes it to rollback uncommitted transactions which may be time consuming. It's not a point-in-time operation as we may used to it.

Brak komentarzy:

Prześlij komentarz