sa_diagnostic_deadlock table

The sa_diagnostic_deadlock table is owned by the dbo user. When diagnostic tracing is enabled and is set to include tracing of deadlock events, a set of rows is inserted into this table every time a deadlock occurs (one row for each connection that was part of the deadlock is inserted). The set of all rows that comprise a single deadlock event is uniquely identified by a snapshot_id.

Columns

Column name	Column type	Description
logging_session_id	UNSIGNED INT	A number uniquely identifying the logging session during which the diagnostic information was gathered.
snapshot_id	UNSIGNED BIGINT	A number identifying which deadlock event this row is a part of. This column has nothing to do with snapshot isolation.
snapshot_at	TIMESTAMP	The time at which the deadlock occurred.
waiter	UNSIGNED INT	The connection number of the connection that this row represents.
request_id	UNSIGNED BIGINT	The ID of the request that this connection was processing when the deadlock occurred.
original_table_object_id	UNSIGNED BIGINT	The object ID of the table on which this connection was blocked.
rowid	UNSIGNED BIGINT	The record ID of the row on which this connection was blocked.
owner	UNSIGNED INT	The connection number of the connection that locked the desired row.
rollback_operation_count	UNSIGNED INT	The number of uncommitted operations.

sa_diagnostic_deadlock table

Columns

See also