Lock:Deadlock Event Class

2016 (13.x) and later versions

Azure

SQL Managed Instance

The Lock:Deadlock event class is produced when an attempt to acquire a lock is canceled

because the attempt was part of a deadlock and was chosen as the deadlock victim.

Use the Lock:Deadlock event class to monitor when deadlocks occur and which objects are

involved. You can use this information to determine if deadlocks are significantly affecting the

performance of your application. You can then examine the application code to determine if

you can make changes to minimize deadlocks.

Description

ApplicationName

Name of the client application that created the

connection to an instance of SQL Server. This

column is populated with the values passed by

the application rather than the displayed name

of the program.

Yes

BinaryData

Lock resource identifier.

Yes

ClientProcessID

ID assigned by the host computer to the process

where the client application is running. This data

column is populated if the client process ID is

provided by the client.

Yes

DatabaseID

ID of the database in which the lock was being

acquired. 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 in which the lock was

being acquired.

Yes

Duration

Amount of time (in microseconds) between the

time the lock request was issued and the time

the deadlock occurred.

Yes

ﾉ

Expand table