| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | helpviewer_keywords | monikerRange | |
|---|---|---|---|---|---|---|---|---|---|---|
Deadlock Graph Event Class |
Deadlock Graph Event Class |
MikeRayMSFT |
mikeray |
03/14/2017 |
sql |
supportability |
reference |
|
=azuresqldb-current||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current |
[!INCLUDE SQL Server] The Deadlock Graph event class provides an XML description of a deadlock. This class occurs simultaneously with the Lock:Deadlock event class.
| 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 [!INCLUDEmsCoName] [!INCLUDEssNoVersion] security login or the [!INCLUDEmsCoName] 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 [!INCLUDEssNoVersion] being traced. | 26 | No |
| SessionLoginName | nvarchar | Login name of the user who originated the session. For example, if you connect to [!INCLUDEssNoVersion] using Login1 and execute a statement as Login2, SessionLoginName shows Login1 and LoginName shows Login2. This column displays both [!INCLUDEssNoVersion] 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 |