第一步:查看死锁表
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
标签:RESOURCE,OBJECT,SERVER,死锁,SQL,ID From: https://www.cnblogs.com/purvis/p/16598562.html