SELECT

    A.SESSION_ID, DATEDIFF(MINUTE, B.LAST_REQUEST_END_TIME, GETDATE()) AS [LOCKING MINUTS],

    B.LOGIN_TIME, B.HOST_NAME, B.PROGRAM_NAME, B.CLIENT_INTERFACE_NAME, B.LOGIN_NAME,

    B.STATUS, B.LAST_REQUEST_START_TIME, B.LAST_REQUEST_END_TIME,

    TEXT

FROM SYS.DM_TRAN_SESSION_TRANSACTIONS AS A

    INNER JOIN SYS.DM_EXEC_SESSIONS AS B ON A.SESSION_ID = B.SESSION_ID

    INNER JOIN SYS.DM_EXEC_CONNECTIONS AS C ON B.SESSION_ID = C.SESSION_ID

CROSS APPLY SYS.DM_EXEC_SQL_TEXT(C.MOST_RECENT_SQL_HANDLE)

WHERE DATEDIFF(MINUTE, B.LAST_REQUEST_END_TIME, GETDATE()) > 0 –사용자시간수정(분)

--=================================================================================

SELECT

    'KILL ' + CONVERT(CHAR(4),SPID) AS [KILL_LIST], SPID, DATEDIFF(SS, LAST_BATCH, GETDATE()) AS [LOCK_TIME],

    LOGINAME, LASTWAITTYPE, CMD, TEXT

FROM SYS.SYSPROCESSES AS A

CROSS APPLY SYS.DM_EXEC_SQL_TEXT(A.SQL_HANDLE)

WHERE OPEN_TRAN >0 AND DATEDIFF(SS, LAST_BATCH, GETDATE()) > 0 – 사용자시간수정(초)

AND SPID > 50