Sql server查询表死锁祥情的语句

select r.session_id,  --会话id
       r.status,      --语句的状态:running,runnable,background,sleeping,suspended
       r.start_time,  --语句在服务器上开始运行的时间
       
       r.command,     --标识正在处理的命令的当前类型
                                           
       s.text         --执行的语句
   ,datediff(ss,r.start_time,getdate()) as [执行秒数]
from sys.dm_exec_requests r
cross apply sys.dm_exec_sql_text(r.sql_handle)s
order by datediff(ss,r.start_time,getdate()) desc

/*

kill 54


*/