Блокировки в SQL Server

CREATE  PROCEDURE [se].[se_TraceLocks]
    @i_s_db AS VARCHAR ( 50 ) = 'db_name',
    @i_n_rsc_type AS INTEGER = NULL
AS
 
DECLARE @i AS INTEGER
SET @i = 1
 
CREATE TABLE #rcs_types (
    rsc_type INTEGER PRIMARY KEY
)
 
IF @i_n_rsc_type IS NULL
    while @i <= 10
    BEGIN
        INSERT INTO #rcs_types ( rsc_type ) VALUES ( @i )
        SET @i = @i + 1
    END
ELSE
    INSERT INTO #rcs_types ( rsc_type ) VALUES ( @i_n_rsc_type )
 
SELECT
    CASE req_mode
        WHEN 0 THEN 'NULL'
        WHEN 1 THEN 'Sch-S'
        WHEN 2 THEN 'Sch-M'
        WHEN 3 THEN 'S'
        WHEN 4 THEN 'U'
        WHEN 5 THEN 'X'
        WHEN 6 THEN 'IS'
        WHEN 7 THEN 'IU'
        WHEN 8 THEN 'IX'
        WHEN 9 THEN 'SIU'
        WHEN 10 THEN 'SIX'
        WHEN 11 THEN 'UIX'
        WHEN 12 THEN 'BU'
        WHEN 13 THEN 'RangeS_S'
        WHEN 14 THEN 'RangeS_U'
        WHEN 15 THEN 'RangeI_N'
        WHEN 16 THEN 'RangeI_S'
        WHEN 17 THEN 'RangeI_U'
        WHEN 18 THEN 'RangeI_X'
        WHEN 19 THEN 'RangeX_S'
        WHEN 20 THEN 'RangeX_U'
        WHEN 21 THEN 'RangeX_X'
    END req_mode,
    CASE rsc_type
        WHEN 1 THEN 'NULL'
        WHEN 2 THEN 'DATABASE'
        WHEN 3 THEN 'FILE'
        WHEN 4 THEN 'INDEX'
        WHEN 5 THEN 'TABLE'
        WHEN 6 THEN 'PAGE'
        WHEN 7 THEN 'KEY'
        WHEN 8 THEN 'EXTENT'
        WHEN 9 THEN 'RID'
        WHEN 10 THEN 'APPLICATION'
    END rsc_type,
    p.hostname, p.program_name, p.cmd, o.name, o.id,
    o.xtype, o.uid, p.hostprocess, p.loginame, rsc_flag,
    CASE req_status
        WHEN 1 THEN 'GRANTED'
        WHEN 2 THEN 'CONVERTING'
        WHEN 3 THEN 'WAITING'
    END req_status,
    req_refcnt, req_lifetime, req_spid, req_ecid,
    CASE req_ownertype
        WHEN 1 THEN 'TRANSACTION'
        WHEN 2 THEN 'CURSOR'
        WHEN 3 THEN 'SESSION'
        WHEN 4 THEN 'EXSESSION'
    END req_ownertype, req_transactionID,
    p.blocked, p.waittype, p.waittime, p.lastwaittype,
    p.waitresource, p.status, p.open_tran,
    b.hostname by_hostname, b.program_name by_program_name,
    b.cmd by_cmd, b.hostprocess by_hostprocess, b.loginame by_loginame
FROM
    master.dbo.syslockinfo l,
    agent.dbo.sysobjects o,
    master.dbo.sysprocesses p
LEFT JOIN master.dbo.sysprocesses b
ON b.spid = p.blocked
WHERE
l.rsc_dbid = (
    SELECT dbid FROM master.dbo.sysdatabases WHERE name = @i_s_db
) AND
o.id = l.rsc_objid AND
p.spid = l.req_spid AND
l.rsc_type IN ( SELECT t.rsc_type FROM #rcs_types t )