MSSDEADLCK - Database Deadlock Information for MSSQL Server
Database Deadlock Information for MSSQL Server information is stored in SAP table MSSDEADLCK.
It is part of development package STUN_MSS in software component BC-DB-MSS. This development package consists of objects that can be grouped under "Package for new SQL Server monitoring objects".
It is part of development package STUN_MSS in software component BC-DB-MSS. This development package consists of objects that can be grouped under "Package for new SQL Server monitoring objects".
Fields for table MSSDEADLCK
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| OCCURTSTMP | Timestamp for deadlock tracking | X | MSSTSTMP | CHAR | 14 | |
| SPID | MS SQL Server process ID | X | MSSSPID | INT2 | 2 | |
| SPNAME | Stored procedure name | MSSSPNAME | CHAR | 128 | ||
| ABAPREPORT | Name of the ABAP report | MSSABNAME | CHAR | 40 | ||
| ABAPLOCAT | Offset of a Processing Control Block | ABP_CONT | INT4 | 4 | ||
| HOSTNAME | Name of the Host Server | MSHOST2 | CHAR | 32 | ||
| HOSTPID | Process ID on app. server | MSSHPID | INT4 | 4 | ||
| WP_NUM | Work process number | MSSWPNUM | INT4 | 4 | ||
| WP_TYPE | Work process type | MSSWPTYPE | CHAR | 2 | ||
| WINNER | Survivor of deadlock flag | MSSWINNER | CHAR | 1 | ||
| SEQ | Deadlock sequence number | MSSSEQ | INT4 | 4 | ||
| TNAME | Table name | MSSTABLE | CHAR | 128 | ||
| MESSAGE | Deadlock message | MSSMSG | CHAR | 255 | ||
| TCODE | Transaction code | MSSTCODE | CHAR | 20 | * |