【SQL Server】判断表格是占锁

查看当前锁的会话

SELECT 
    request_session_id AS 'Session ID',
    resource_type AS 'Resource Type',
    resource_database_id AS 'Database ID',
    resource_associated_entity_id AS 'Object ID',
    resource_description AS 'Resource Description',
    request_mode AS 'Lock Mode'
FROM 
    sys.dm_tran_locks
WHERE 
    resource_database_id = DB_ID('YourDatabaseName');

 查看等待锁的会话

SELECT 
    r.session_id, 
    r.status, 
    r.wait_type, 
    r.wait_time, 
    r.blocking_session_id, 
    t.text AS 'Running Query'
FROM 
    sys.dm_exec_requests r
CROSS APPLY 
    sys.dm_exec_sql_text(r.sql_handle) t
WHERE 
    r.blocking_session_id <> 0;

 查看锁的持有者和等待者信息

-- 查看当前锁信息
EXEC sp_lock;