Data Description

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.

Splunk Event

The event will look like this in Splunk:

SAP Navigation

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.