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.