Data Element list used by SAP ABAP Table MSSBLOCKINGLOCKHIER (Blocking lock hierarchy display)
SAP ABAP Table
MSSBLOCKINGLOCKHIER (Blocking lock hierarchy display) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
| 1 | MSSBLKSESSIONID | Blocking session ID for SQL Server | ||
| 2 | MSSCOMMAND | MS SQL Server command | ||
| 3 | MSSHOSTNM_ | Hostname of the application server logged into SQL Server | ||
| 4 | MSSINT4 | SQL Server int4 | ||
| 5 | MSSINT4 | SQL Server int4 | ||
| 6 | MSSLCKSEQ | Lock sequence number | ||
| 7 | MSSLCKSQLTXT | Beginning characters of a sql statement in a lock hierarchy | ||
| 8 | MSSLCKWAITTYP | Lock wait type | ||
| 9 | MSSLOCKMODE | req_mod from syslockinfo for blocking/blocked lock entry | ||
| 10 | MSSPLANHANDLE | handle pointing to plan used in execution of sql stmt/proc | ||
| 11 | MSSPRGNAME | Name of the application program which owns the connection | ||
| 12 | MSSREQUESTID | SQL Server Request ID | ||
| 13 | MSSSESSIONID | Session ID for SQL Server | ||
| 14 | MSSSQLHANDLE | handle pointing to sql statment or procedure | ||
| 15 | MSSWAITRSC | Wait Resource as seen in sysprocesses | ||
| 16 | MSSWAITSEC | Current wait time of the process in seconds |