Lock:Deadlock Chain Event Class

2016 (13.x) and later versions

Azure

SQL Managed Instance

The Lock:Deadlock Chain event class is produced for each participant in a deadlock.

Use the Lock:Deadlock Chain event class to monitor when deadlock conditions occur. This

information is useful to determine if deadlocks are significantly affecting the performance of

your application, and which objects are involved. You can examine the application code that

modifies these objects to determine if changes to minimize deadlocks can be made.

Description

BinaryData

Lock resource identifier.

Yes

DatabaseID

ID of the database to which this resource

belongs. SQL Server Profiler displays the name

of the database if the ServerName data column

is captured in the trace and the server is

available. Determine the value for a database by

using the DB_ID function.

Yes

DatabaseName

Name of the database to which the resource

belongs.

Yes

EventClass

Type of event = 59.

EventSequence

Sequence of a given event within the request.

EventSubClass

Type of event subclass.

101=Resource type Lock

102=Resource type Exchange

Yes

IntegerData

Deadlock number. Numbers are assigned

beginning with 0 when the server is started, and

incremented for each deadlock.

Yes

IntegerData2

Identified for informational purposes only. Not

supported. Future compatibility is not

Yes

ﾉ

Expand table