Have you ever thought what is a reason that makes Rollback time consuming process?
Whenever you kill some spid or rollback transaction it would take 3 or 4 times more time then it has taken to execute that particular batch/transaction!!!! The reason is that the Rollback is single threaded and hence it most likely to take much longer time read complete article here
1/06/2009
Why rollback is taking much longer time
7:07 PM
kill spid, performance tuning, pss engineers, recovery, rollback, rollback is single threaded, rollback takes more time, rollback takes much longer time
No comments
0 comments:
Post a Comment
I appreciate your time, thanks for posting your comment. I will review and reply to your comment as soon as I can.
Thank you
Hemantgiri