select request_session_id spid
,OBJECT_NAME(resource_associated_entity_id)tableName from sys.dm_tran_locks where resource_type = 'OBJECT 'spid 就是锁住表的进程
tableName 就是被锁的表名本文共 240 字，大约阅读时间需要 1 分钟。
select request_session_id spid
,OBJECT_NAME(resource_associated_entity_id)tableName from sys.dm_tran_locks where resource_type = 'OBJECT 'spid 就是锁住表的进程
tableName 就是被锁的表名转载于:https://www.cnblogs.com/ppcompany/archive/2012/10/08/2715457.html