RE: Kill long running transactions

SSC Guru

Points: 398694

February 8, 2018 at 6:28 pm

You can bounce the server. Sometimes that works. Other times it stops the rollback which then has to start up again, from scratch.

Look to see if there is blocking on the rollback.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt