The suspended process is not ended when time out and can not be killed - by William.zhang

Status : 


Sign in
to vote
ID 869908 Comments
Status Active Workarounds
Type Bug Repros 0
Opened 5/8/2014 8:07:42 PM
Access Restriction Public


The process which executes a full text index query in sql server 2012 stays at suspended status for three days and the host process of the sql command is terminated by IIS.

Then I run the 'kill @@spid' command, the process switches to killed/rollback status but can not ended. I try detach the database and it keeps loading and loading.

The process should be terminated when timeout. 

Sign in to post a comment.