LOCK 체크 (sysprocesses)

DECLARE @cTime INT DECLARE @checkTime DATETIME SET @cTime = 3 SET @checkTime = DATEADD(MINUTE, -@cTime, GETDATE()) SELECT spid, kpid, blocked, a.dbid, login_time, last_batch, open_tran, status, hostname, program_name, sql_handle, b.text FROM master.dbo.sysprocesses A cross apply SYS.DM_EXEC_SQL_TEXT(a.sql_handle) B WHERE a.open_tran > 0 and A.last_batch < @checkTime

2019.03.22