Deadlock Graph Event Class


Applies To: SQL Server 2016

The Deadlock Graph event class provides an XML description of a deadlock. This class occurs simultaneously with the Lock:Deadlock event class.

Data column nameData typeDescriptionColumn IDFilterable
EventClassintType of event = 148.27No
EventSequenceintSequence of a given event within the request.51No
IsSystemintIndicates whether the event occurred on a system process or a user process. 1 = system, 0 = user. This value is always 1 for this event.60Yes
LoginNamenvarcharName of the login of the user (either the Microsoft SQL Server security login or the Microsoft Windows login credentials in the form of DOMAIN\username). This value is always the system user for this event.11Yes
LoginSidimageSecurity identification number (SID) of the logged-in user. You can find this information in the sys.server_principals catalog view. Each SID is unique for each login in the server. This value is always the SID of the system user for this event.41Yes
ServerNamenvarcharName of the instance of SQL Server being traced.26No
SessionLoginNamenvarcharLogin name of the user who originated the session. For example, if you connect to SQL Server using Login1 and execute a statement as Login2, SessionLoginName shows Login1 and LoginName shows Login2. This column displays both SQL Server and Windows logins.64Yes
SPIDintID of the session on which the event occurred.12Yes
StartTimedatetimeTime at which the deadlock was detected.14Yes
TextDatantextXML description of the deadlock.1Yes
TransactionIDbigintNot used.4Yes

sp_trace_setevent (Transact-SQL)
Lock:Deadlock Event Class

Community Additions