SQL SERVER 查看处理死锁方法
第一步:查看死锁表
SELECT OBJECT_NAME(RESOURCE_ASSOCIATED_ENTITY_ID) AS TABLENAME, REQUEST_SESSION_ID AS PID FROM SYS.DM_TRAN_LOCKS WHERE RESOURCE_TYPE = 'OBJECT';
第二步:结束死锁进程
KILL 218
第一步:查看死锁表
SELECT OBJECT_NAME(RESOURCE_ASSOCIATED_ENTITY_ID) AS TABLENAME, REQUEST_SESSION_ID AS PID FROM SYS.DM_TRAN_LOCKS WHERE RESOURCE_TYPE = 'OBJECT';
第二步:结束死锁进程
KILL 218