SAP ABAP Table MSSXEDEADLCK (Deadlock Information for MSSQL Server from X-Events)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-MSS (Application Component) Microsoft SQL Server
     ⤷ STUN_MSS (Package) Package for new SQL Server monitoring objects

Basic Data

Table Category	INTTAB	Structure
Structure	MSSXEDEADLCK	Table Relationship Diagram
Short Description	Deadlock Information for MSSQL Server from X-Events

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	DT	☐	MSSDLDT	DATUM	DATS	8	0	Date when a deadlock occurred
2	TM	☐	MSSDLTM	SYTIME	TIMS	6	0	Time when deadlock occurred
3	PROCESSID	☐	MSSDLPID		CHAR	32	0	Deadlock process ID
4	VICTIM	☐	MSSDLVICTIM	BOOLEAN	CHAR	1	0	Was this process a victim
5	SPID	☐	MSSSPID	INT2	INT2	5	0	MS SQL Server process ID
6	DB	☐	MSSDB	MSSSYSNAME	CHAR	128	0	Database name
7	WAITRESOURCE	☐	MSSWAITRSC		CHAR	40	0	Wait Resource as seen in sysprocesses
8	WAITTIME	☐	MSSDLWAITTM		DEC	20	0	Process wait time
9	HOSTNAME	☐	MSSAPPHOST	MSHOST	CHAR	20	0	Application server name
10	HOSTPID	☐	MSSHOSTPID	WPPID	CHAR	8	0	MS SQL-Server host process id (= OS work process ID)
11	LOGINNAME	☐	MSSLOGINNAME	MSSSYSNAME	CHAR	128	0	Login name
12	INPUTBUF	☐	MSSINPUTBUFF		CHAR	40	0	Output from DBCC INPUTBUFFER for lock display
13	TXACTNAME	☐	MSSTXACT		CHAR	64	0	Transaction name
14	OWNEROBJNAME	☐	MSSOWNOBJ		CHAR	512	0	Owner object name
15	OWNERINDNAME	☐	MSSOWNIND		CHAR	512	0	Owner index name
16	OWNERMODE	☐	MSSOWNMODE		CHAR	20	0	Owner mode
17	WAITEROBJNAME	☐	MSSWAITEROBJ		CHAR	512	0	Waiter object name
18	WAITERINDNAME	☐	MSSWAITERIND		CHAR	512	0	Waiter index name
19	WAITERMODE	☐	MSSWAITERMODE		CHAR	20	0	Waiter mode
20	DEADLOCKGRAPH	☐	MSSDLGRAPH	STRING	STRG	0	0	Deadlock graph
21	SQLHANDLE	☐	MSSSQLHANDLE	MSSHANDLE	CHAR	130	0	handle pointing to sql statment or procedure
22	STMT_START_OFFSET	☐	MSSSTARTOFFSET	INT4	INT4	10	0	Start statement offset
23	STMT_END_OFFSET	☐	MSSENDOFFSET	INT4	INT4	10	0	Statement end offset

History

Last changed by/on	SAP	20130604
SAP Release Created in	732