Find out session ID of blocked processes and kill it

Find out session ID with below script:

 

select spid 被锁进程ID,
 blocked 锁进程ID,
 status 被锁状态,
 SUBSTRING(SUSER_SNAME(sid),1,30) 被锁进程登陆帐号,
 SUBSTRING(hostname,1,12) 被锁进程用户机器名称,
 SUBSTRING(DB_NAME(a.dbid),1,10) 被锁进程数据名称,
 cmd 被锁进程命令,
 waittype 被锁进程等待类型,b.text SQL
FROM master..sysprocesses  a
CROSS APPLY sys.dm_exec_sql_text(a.sql_handle) b
WHERE blocked>0 AND spid<>blocked

 

Kill session ID:

 

Kill <session ID>