查询数据库锁信息

SELECT
 DB_NAME(l.resource_database_id) AS DatabaseName,
 OBJECT_NAME(p.object_id) AS TableName,
 l.request_mode AS LockMode,
 l.request_status AS LockStatus,
 r.session_id AS SessionID,
 r.start_time AS StartTime
FROM sys.dm_tran_locks l
JOIN sys.dm_exec_requests r ON l.request_session_id = r.session_id
JOIN sys.partitions p ON p.hobt_id = l.resource_associated_entity_id

DatabaseName：锁定的数据库名称

TableName：锁定的表名称

LockMode：锁的模式（共享、排他等）

LockStatus：锁的状态（阻塞、等待等）

SessionID：持有锁的会话 ID

StartTime：锁定的时间