The deadlock instance (all rows pertaining to a particular deadlock have the same ID).
The time when the deadlock occurred.
The connection handle of the waiting connection.
The user ID associated with the connection that is waiting.
The command being executed by the waiting connection.
This information is only available if you have turned on capturing of the most recently-prepared SQL statement by specifying
the -zl option on the database server command line or have turned this feature on using the sa_server_option system procedure.
The object ID of the table containing the row.
The row ID of the associated row.
The connection handle of the connection owning the lock being waited on.
Identifies the rolled back transaction.
The number of uncommitted operations that may be lost if the transaction rolls back.
When the log_deadlocks option is set to On, the database server logs information about deadlocks in an internal buffer. You
can view the information in the log using the sa_report_deadlocks system procedure.