How to terminate a suspended SQL Server transaction waiting for IO_COMPLETION?

9 votes

1 answer

16069 views

sql-server-2012 transaction kill

                          We have a transaction that has been running for more than 5 hours. We are running out of disk space. The session has been killed but it is still waiting for IO_COMPLETION. Actually the wait_type just changed to PAGEIOLATCH_EX. How can I terminate the suspended SQL Server transaction? I am not worried about losing data since all of it can be repopulated.

    session_id: 54
    STATUS: suspended
    blocked by: 0
    wait_type: PAGEIOLATCH_EX
    Elapsed Time (in Sec): 19750.420000
    open_transaction_count: 2

Asked by Tarzan (557 rep)

Jun 3, 2015, 04:20 PM
Last activity: May 13, 2020, 06:49 PM

How to terminate a suspended SQL Server transaction waiting for IO_COMPLETION?

Related Questions