Post reply

KILL not working

  • December 15, 2003 at 11:47 am

    #64887

    I am trying to kill a process that shows up as runnable, but the process won't go away. Any suggestions?

    Thanks

  • December 15, 2003 at 11:57 am

    #486234

    The process you are trying to kill, did it perform a lot of operations? One thing to remember about the KILL command is it will attempt to roll back any operations performed by the SPID that are uncommitted.

    Sometimes, of course, this doesn't work and restarting the service is your only option. However, before you resort to this, look at the usage of the SPID using queries against sysprocesses to make sure it isn't hung.

    K. Brian Kelley, GSEC

    http://www.truthsolutions.com/

    Author: Start to Finish Guide to SQL Server Performance Monitoring

    http://www.netimpress.com/

    K. Brian Kelley
    @kbriankelley

  • December 15, 2003 at 12:02 pm

    #486239

    The command being executed is BACKUP DATABASE... and has been running since Dec. 6. There is a lot of CPUtime and DiskIO associated with the SPID, but I don't think there is anything to roll back. Is there any way to remove this orphan process (if that's what it is) without having to cycle SQL Server? Can I drop a row from sysprocesses, for example?

  • December 15, 2003 at 12:05 pm

    #486240

    Is this backup process created by maintenance wizard? If it was, go to server task manager, find the sqlmaint.exe and kill it.

  • December 15, 2003 at 12:16 pm

    #486241

    No, the backup process is a third party product called Backup Exec running on a different server.

  • December 15, 2003 at 1:08 pm

    #486250

    Killing the Backup Exec process (restarting the service) on the other machine should take care of it. If there is a SQL Server scheduled task, restarting SQL Agent should also work.

  • December 15, 2003 at 2:59 pm

    #486271

    Thank you jxflagg. The suggestion to stop the third party service did the job.

  • December 16, 2003 at 4:34 am

    #486350

    Try undocumented DBCC PSS with your SPID, it should sugest the status of the process, and then you can decide whether you can rollback it or take some other action.

  • December 17, 2003 at 12:12 pm

    #486772

    quote:

    Try undocumented DBCC PSS with your SPID, it should sugest the status of the process, and then you can decide whether you can rollback it or take some other action.

    What are the valid parameters for dbcc pss?

Viewing 9 posts - 1 through 8 (of 8 total)

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