트랜잭션 행걸렸을때 해결방법

-- 실행중인 트랜잭션 조회
SELECT 
    blocking_session_id AS BlockingSessionID,
    session_id AS WaitingSessionID,
    wait_type,
    wait_time,
    wait_resource
FROM sys.dm_exec_requests
WHERE blocking_session_id <> 0;
-- 해당 트랜잭션 삭제
KILL <blocking_session_id>;

바로 실행할 경우

SELECT 
    blocking_session_id AS BlockingSessionID,
    session_id AS WaitingSessionID,
    wait_type,
    wait_time,
    wait_resource
FROM sys.dm_exec_requests
WHERE blocking_session_id <> 0;

DECLARE @V_Blocking_session_id INT;
SELECT 
    @V_Blocking_session_id = blocking_session_id,
FROM sys.dm_exec_requests
WHERE blocking_session_id <> 0;
-- 해당 트랜잭션 삭제
KILL @V_Blocking_session_id;