MSSCNTDEAD - Cumulated deadlock statistics data
Cumulated deadlock statistics data information is stored in SAP table MSSCNTDEAD.
It is part of development package STUS in software component BC-DB-MSS-CCM. This development package consists of objects that can be grouped under "SQL Server Monitor".
It is part of development package STUS in software component BC-DB-MSS-CCM. This development package consists of objects that can be grouped under "SQL Server Monitor".
Fields for table MSSCNTDEAD
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| SPNAME | Stored procedure name | X | MSSSPNAME | CHAR | 128 | |
| ABAPREPORT | Name of the ABAP report | X | MSSABNAME | CHAR | 40 | |
| WP_TYPE | Work process type | X | MSSWPTYPE | CHAR | 2 | |
| WINNER | Survivor of deadlock flag | X | MSSWINNER | CHAR | 1 | |
| COUNTER | Number of occurrences of one certain deadlock. | MSSDEADCNT | INT4 | 4 | ||
| TNAME | Table name | MSSTABLE | CHAR | 128 | ||
| LASTTSTMP | Timestamp of last run updating deadlock count. | MSSLASTTIM | CHAR | 14 |