select request_session_id spid,OBJECT_NAME(resource_associated_entity_id)tableName from sys.dm_tran_locks where resource_type = 'OBJECT '
spid 就是锁住表的进程 tableName 就是被锁的表名
