— Query to find how long a rollback will take to complete
SELECT session_id as SPID, command, start_time, getdate() as CurrentTime,
percent_complete, (estimated_completion_time/1000)/60 as minutes_remaining,
dateadd(second,(estimated_completion_time/1000), getdate()) as estimated_completion_time
FROM sys.dm_exec_requests where percent_complete > 0
–and session_id=158
go