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.

Field Mapping

Field

Description

Unit of Measure

ABAPLOCAT

Offset of a Processing Control Block

Number

ABAPREPORT

Name of the ABAP report

String

CURRENT_TIMESTAMP

The date time stamp when the information was collected

YYYYMMDDHHMMSS

EVENT_SUBTYPE

String

EVENT_TYPE

MSS_DB02_DDLK

String

HOSTNAME

Name of the Host Server

String

HOSTPID

Process ID on app. server

Number

MESSAGE

Deadlock message

String

OCCURTSTMP

Timestamp for deadlock tracking

YYYYMMDDHHMMSS

SEQ

Deadlock sequence number

Number

SPID

MS SQL Server process ID

Number

SPNAME

Stored procedure name

String

TCODE

Transaction code

String

TNAME

Table name

String

UTCDIFF

The UTC OFFSSET in HHMMSS that the data was collected in

HHMMSS

UTCSIGN

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.

+ | -

WINNER

Survivor of deadlock flag

Boolean

WP_NUM

Work process number

Number

WP_TYPE

Work process type

String