KILLED and ROLLBACK

Find session in state of killed or rollback

Last updated: 27 December 2016

Warning: Review and test in a non-production environment before running.

Back to results

SELECT spid
,kpid
,login_time
,last_batch
,status
,hostname
,nt_username
,loginame
,hostprocess
,cpu
,memusage
,physical_io
FROM sys.sysprocesses
WHERE cmd = 'KILLED/ROLLBACK'