Kill with status only shows 'Estimated rollback completion: 0%. Estimated time remaining: 0 seconds'

_{Tuesday, September 3, 2013 4:46 PM}

Environment:

SQL Server ENT 2012  SP1 CU5 on Windows 2012.

I killed a process executing a stored procedure and when I check the rollback status it shows the following:

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

The procedure typically takes 5 mins to complete, so the rollback should not take much longer than that.

It's been showig the same status for 12 hours now.

The following entry has been added to the error log for the past 12 hours every minute:

Process 860:0:2 (0x1aa0) Worker 0x0000001F09212160 appears to be non-yielding on Scheduler 5. Thread creation time: 13022616777957. Approx Thread CPU Used: kernel 2792 ms, user 27288693 ms. Process Utilization 19%. System Idle 79%. Interval: 40543269 ms.

Any suggestions on how to remedy this?
Thank you,

Mike

_{Tuesday, September 3, 2013 5:09 PM}

Restart SQL SERVER!!!

The most important motivation for the research work that resulted in the relational model was the objective of providing a sharp and clear boundary between the logical and physical aspects of database management. - E. F. Codd

My blog

_{Tuesday, September 3, 2013 5:14 PM}

Hello SQL Mike,

I agree with Saeid ,you might have to restart SQL server I did once in SQL server 2008 to resolve such issue.

But sad to find out this is happening in SQL 2012

Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers

_{Tuesday, September 3, 2013 5:56 PM}

Thank you, guys. I was hoping to avoid that as we've seen this issue in the past and were forced to restart the server.