Friday, July 2, 2021

Buggish: transaction rollback in progress. Estimated rollback completion: 0%. Estimated time remaining: 0 seconds. (no answer)

 I tried killing this SQL session, but it never disappears. When I use "KILL ## WITH STATUSONLY", I get:

SPID ##: transaction rollback in progress. Estimated rollback completion: 0%. Estimated time remaining: 0 seconds.


I know what is executing it which was my web tool that edits the sql server. I tried restarting the App Pool but this did not do anything. I eventually IISRESTART and the session disappears.

No comments:

Post a Comment