Data Element list used by SAP ABAP Table MSSXEDEADLCK (Deadlock Information for MSSQL Server from X-Events)
SAP ABAP Table
MSSXEDEADLCK (Deadlock Information for MSSQL Server from X-Events) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
| 1 | MSSAPPHOST | Application server name | ||
| 2 | MSSDB | Database name | ||
| 3 | MSSDLDT | Date when a deadlock occurred | ||
| 4 | MSSDLGRAPH | Deadlock graph | ||
| 5 | MSSDLPID | Deadlock process ID | ||
| 6 | MSSDLTM | Time when deadlock occurred | ||
| 7 | MSSDLVICTIM | Was this process a victim | ||
| 8 | MSSDLWAITTM | Process wait time | ||
| 9 | MSSENDOFFSET | Statement end offset | ||
| 10 | MSSHOSTPID | MS SQL-Server host process id (= OS work process ID) | ||
| 11 | MSSINPUTBUFF | Output from DBCC INPUTBUFFER for lock display | ||
| 12 | MSSLOGINNAME | Login name | ||
| 13 | MSSOWNIND | Owner index name | ||
| 14 | MSSOWNMODE | Owner mode | ||
| 15 | MSSOWNOBJ | Owner object name | ||
| 16 | MSSSPID | MS SQL Server process ID | ||
| 17 | MSSSQLHANDLE | handle pointing to sql statment or procedure | ||
| 18 | MSSSTARTOFFSET | Start statement offset | ||
| 19 | MSSTXACT | Transaction name | ||
| 20 | MSSWAITERIND | Waiter index name | ||
| 21 | MSSWAITERMODE | Waiter mode | ||
| 22 | MSSWAITEROBJ | Waiter object name | ||
| 23 | MSSWAITRSC | Wait Resource as seen in sysprocesses |