How to terminate a Litespeed process (SPID) in SQL Server? (4284999)

How do you kill Litespeed processes (SPIDs) that appears to be hanging in SQL Server?

To end a Litespeed process, end the following tasks in Task Manager: LiteSpeed.exe, slssqlmaint.exe, sqllitespeed.exe or sqllitespeedx64.exe services. Killing a SPID without ending the task will simply cause the service to restart the SPID.

Otherwise, you may want to specifically identify the SPID:

To identify the SPID, type and run Select session_id, Text
from sys.dm_exec_requests r
cross apply sys.dm_exec_sql_text(sql_handle) t

Do
KILL spid WITH STATUSONLY
Then
Select * from sys.Sysprocesses

Within the results pane you will see the KPID number corresponding to your SPID.
Logon to the server remotely | open Task Manager to find this KPID number. Once you are satisifed then you can proceed to kill the process from Task Manager.

Killing a SPID and Checking Rollback progress in SQL Server

http://www.mssqltips.com/tip.asp?tip=1473

kill 52 with statusonly

Also see: Solution SOL25864