Hanging session in SQL Server

5 pts.
Tags:
SQL Database
SQL Server
A session is in KILL/ROLLBACK state for some time. I do not want the database to become inconsistent and would like some help on the steps on how to solve this.
kill 85 with statusonly;
SPID 85: transaction rollback in progress. Estimated rollback completion: 0%. Estimated time remaining: 0 seconds.
sp_whoisactive

dd hh:mm:ss.mss session_id sql_text login_name wait_info CPU tempdb_allocations tempdb_current blocking_session_id reads writes physical_reads used_memory status open_tran_count percent_complete host_name database_name program_name start_time login_time request_id collection_time

09 15:02:39.800 85

INSERT INTO fas_ORA_S_POLISSEN_CODA_V SELECT *, GETDATE(), 'xxxx', NULL, 0 FROM (SELECT * FROM OPENQUERY(AVANSE, 'SELECT * FROM S_POLISSEN_CODA_V WHERE POLISNUMMER IN (SELECT POLISNUMMER FROM S_POLISSEN_AUDITS WHERE FASILA_STATUS = 1)')) dummy

--?> CODA (831756022ms)OLEDB                     16                   8                   8 NULL                         47                         4                     0                   7 runnable                   2 NULL ENNIASPRD01 FAS_CODA .Net SqlClient Data Provider 2015-12-21 12:14:39.990 2015-12-21 12:14:39.990 0 2015-12-31 03:17:19.807
What is the best way to stop this process?

Regards,

Mia12345



Software/Hardware used:
SqlServer 2012
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: