--- title: "Deadlock Graph Event Class | Microsoft Docs" ms.custom: "" ms.date: "03/14/2017" ms.prod: sql ms.reviewer: "" ms.technology: supportability ms.topic: conceptual helpviewer_keywords: - "Deadlock Graph event class" ms.assetid: 20f92233-c912-4382-8993-8e2e23d03fbe author: "stevestein" ms.author: "sstein" monikerRange: "=azuresqldb-current||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current" --- # Deadlock Graph Event Class [!INCLUDE[appliesto-ss-xxxx-xxxx-xxx-md](../../includes/appliesto-ss-xxxx-xxxx-xxx-md.md)] The **Deadlock Graph** event class provides an XML description of a deadlock. This class occurs simultaneously with the **Lock:Deadlock** event class. ## Deadlock Graph Event Class Data Columns |Data column name|Data type|Description|Column ID|Filterable| |----------------------|---------------|-----------------|---------------|----------------| |**EventClass**|**int**|Type of event = 148.|27|No| |**EventSequence**|**int**|Sequence of a given event within the request.|51|No| |**IsSystem**|**int**|Indicates whether the event occurred on a system process or a user process. 1 = system, 0 = user. This value is always 1 for this event.|60|Yes| |**LoginName**|**nvarchar**|Name of the login of the user (either the [!INCLUDE[msCoName](../../includes/msconame-md.md)] [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] security login or the [!INCLUDE[msCoName](../../includes/msconame-md.md)] Windows login credentials in the form of DOMAIN\username). This value is always the system user for this event.|11|Yes| |**LoginSid**|**image**|Security 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.|41|Yes| |**ServerName**|**nvarchar**|Name of the instance of [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] being traced.|26|No| |**SessionLoginName**|**nvarchar**|Login name of the user who originated the session. For example, if you connect to [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] using Login1 and execute a statement as Login2, **SessionLoginName** shows Login1 and **LoginName** shows Login2. This column displays both [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] and Windows logins.|64|Yes| |**SPID**|**int**|ID of the session on which the event occurred.|12|Yes| |**StartTime**|**datetime**|Time at which the deadlock was detected.|14|Yes| |**TextData**|**ntext**|XML description of the deadlock.|1|Yes| |**TransactionID**|**bigint**|Not used.|4|Yes| ## See Also [sp_trace_setevent (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-trace-setevent-transact-sql.md) [Lock:Deadlock Event Class](../../relational-databases/event-classes/lock-deadlock-event-class.md)