The MSS_DB02_DDLK event is used in SAP to view database deadlocks for a Microsoft SQL database.
Potential Use Cases
This event could be used in the following scenarios:
Alert on deadlocks in the environment.
Correlate database deadlocks with particular application activity such as batch job.
Dashboard deadlocks in the environment.
The event will look like this in Splunk:
Log into the managed system and execute the dbacockpit transaction code. Expand the Diagnostics menu option on the left side of the screen and double-click the Deadlock Monitor option. The information displayed will match the data that is extracted and sent to Splunk.
Unit of Measure
Offset of a Processing Control Block
Name of the ABAP report
The date time stamp when the information was collected
Name of the Host Server
Process ID on app. server
Timestamp for deadlock tracking
Deadlock sequence number
MS SQL Server process ID
Stored procedure name
The UTC OFFSSET in HHMMSS that the data was collected in
The UTC positive or negative OFFSET indicator. Positive (+) means add UTCDIFF to find the time zone of the data, negative (-) means subtract the UTCDIFF to find the time zone adjusted date time the data was collected in.
+ | -
Survivor of deadlock flag
Work process number
Work process type