Post reply

Blocking process cannot be killed

  • November 6, 2003 at 8:50 am

    #160086

    I identified two blocking processes. One is a scheduled job,spid=20, the other is select stmt from the table that is blocked, spid=80. I tried to kill 20.The command completed successfully, but the process is still there. Same thing happened on the 80.

    I have system admin and process admin. rights.

    Any suggestion?

    Thanks in advance.

  • November 6, 2003 at 9:15 am

    #481097

    The spid 20 could be in 'rollbak' status but spid 80 should ne killed immediately if it is select statement only.

  • November 6, 2003 at 9:23 am

    #481099

    Yes, you are right. spid 80 is gone. But spid 20 blocking is 0 status is running. It has a rollback transaction. I tried to stopped the job, it said the job is not running. How can I kill it?

    Thanks

  • November 6, 2003 at 12:13 pm

    #481142

    The process status =runable, open transactions = 1, command=execute,blocking=0

    I still cannot kill it. Any comments?

    Thanks

  • November 6, 2003 at 12:17 pm

    #481144

    You have to wait the rollback to complete. Force SQL Server Agent to stop to kill the rollback process could cause protential database integrity issues.

  • November 7, 2003 at 7:21 am

    #481243

    Thanks, The table is back.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply