遇到死锁, 如何快速处理?

查询流水号表死锁(未测试)

USE yxhis

GO

SELECT distinct 'kill '+CONVERT (VARCHAR, req_spid) AS 处置方法, CONVERT (SMALLINT, req_spid) AS spid, 
rsc_dbid AS dbid, 
rsc_objid AS ObjId, 
rsc_indid AS IndId 
FROM 
master.dbo.syslockinfo 
WHERE rsc_objid IN(SELECT id FROM yxhis..sysobjects WHERE NAME IN('tbsysparam','tbsysparam2'))