Lock 체크 (DMV)

-- 10분이상 들어오지 않은 Request 확인
SELECT
    st.session_id, datediff(minute, last_request_end_time, getdate()), text, last_read, last_write, getdate(), *
    from sys.dm_tran_session_transactions st
    inner join sys.dm_exec_sessions es
    on es.session_id = st.session_id
    inner join sys.dm_exec_connections ec
    on ec.session_id = es.session_id
    cross apply sys.dm_exec_sql_text(ec.most_recent_sql_handle)
    where datediff(minute, last_request_end_time, getdate()) > 10