Data Element list used by SAP ABAP Table MSSDBLOCKS_SNAP (DB Locks snapshot - includes handles)
SAP ABAP Table MSSDBLOCKS_SNAP (DB Locks snapshot - includes handles) is using
# | Object Type | Object Name | Object Description | Note |
---|---|---|---|---|
1 | Data Element | MSSBLKSPID | MS SQL Server process ID (blocking) | |
2 | Data Element | MSSCHARLOCKTYP | Char representation of rsc_type from syslockinfo | |
3 | Data Element | MSSCOMMAND | MS SQL Server command | |
4 | Data Element | MSSHOSTNM_ | Hostname of the application server logged into SQL Server | |
5 | Data Element | MSSHOSTPID | MS SQL-Server host process id (= OS work process ID) | |
6 | Data Element | MSSINPUTBUFF | Output from DBCC INPUTBUFFER for lock display | |
7 | Data Element | MSSINT4 | SQL Server int4 | |
8 | Data Element | MSSINT4 | SQL Server int4 | |
9 | Data Element | MSSLASTWTYPE | Last Wait Type as seen in sysprocesses | |
10 | Data Element | MSSLDBNAME | MS SQL Server: Database name | |
11 | Data Element | MSSLOCKMODE | req_mod from syslockinfo for blocking/blocked lock entry | |
12 | Data Element | MSSLOCKRSC | Textual description of a lock resource from syslockinfo | |
13 | Data Element | MSSLOCKTXT | MS SQL Server lock description text | |
14 | Data Element | MSSOBJNAME | MS SQL Server object name | |
15 | Data Element | MSSOPENTRAN | Number of open transactions for the SQL Server process | |
16 | Data Element | MSSPLANHANDLE | handle pointing to plan used in execution of sql stmt/proc | |
17 | Data Element | MSSPRGNAME | Name of the application program which owns the connection | |
18 | Data Element | MSSREQOWNTYP | req_refcnt from syslockinfo for blocking/blocked lock entry | |
19 | Data Element | MSSREQREFCNT | req_refcnt from syslockinfo for blocking/blocked lock entry | |
20 | Data Element | MSSREQSPID | MS SQL Server process ID | |
21 | Data Element | MSSSQLHANDLE | handle pointing to sql statment or procedure | |
22 | Data Element | MSSSTATUS | MS SQL-Server process status | |
23 | Data Element | MSSTNAME | Table name | |
24 | Data Element | MSSUNAME | MS SQL Server user name | |
25 | Data Element | MSSWAITRSC | Wait Resource as seen in sysprocesses | |
26 | Data Element | MSSWAITTIME | Current wait time of the process in milliseconds |