Locks Data Columns
The following table lists the data columns for each event class in the Locks event category.
| Event class | Data column | Description |
|---|---|---|
| Lock:Acquired | Event Class | Type of event recorded = 24. |
| Mode | Lock mode, such as intent exclusive, of the lock that was acquired. | |
| Binary Data | Resource type. | |
| End Time | End time of the event. | |
| Duration | Wait between the time the lock request was issued and the time the lock was acquired. | |
| Object ID | ID of the object on which the lock was acquired. | |
| Index ID | ID of the index, if the object lock was on an index. | |
| Lock:Cancel | Event Class | Type of event recorded = 26. |
| Mode | Mode of the lock that was canceled. | |
| Binary Data | Resource type. | |
| End Time | End time of the event. | |
| Duration | Wait between the time the lock requested was issued and the time the lock was canceled. | |
| Object ID | ID of the object on which the lock was canceled. | |
| Index ID | ID of the index, if the object lock was on an index. | |
| Lock:Deadlock | Event Class | Type of event recorded = 25. |
| Mode | Lock mode of the lock that triggered the deadlock. | |
| Binary Data | Resource type. | |
| End Time | End time of the deadlock. | |
| Integer Data | Deadlock number. Numbers are assigned, beginning with zero, when the server is started and incremented for each deadlock. | |
| Duration | Wait between the time the lock request was issued and the time the deadlock occurred. | |
| Object ID | ID of the object in contention. | |
| Index ID | ID of the index, if the object lock was on an index. | |
| Lock:Deadlock Chain | Event Class | Type of event recorded = 59. |
| Mode | Lock mode of each lock in the deadlock chain. | |
| Binary Data | Resource type. | |
| Integer Data | Deadlock number. Numbers are assigned, beginning with zero, when the server is started and incremented for each deadlock. | |
| Object ID | ID of the object that was locked. | |
| Index ID | ID of the index, if the object lock was on an index. | |
| Lock:Escalation | Event Class | Type of event recorded = 60. |
| Object ID | ID of the object on which the lock was escalated. | |
| Index ID | ID of the index, if the object lock was on an index. | |
| Mode | Lock mode after the escalation. | |
| Lock:Released | Event Class | Type of event recorded = 23. |
| Binary Data | Resource type. | |
| End Time | End time of the event. | |
| Duration | Wait time between the time the lock request was issued and the time the lock was released. | |
| Object ID | ID of the object on which the lock was released. | |
| Index ID | ID of the index, if the object lock was on an index. | |
| Lock:Timeout | Event Class | Type of event recorded = 27. |
| Mode | Lock mode of the requested lock that has timed out. | |
| Binary Data | Resource type. | |
| End Time | End time of the event. | |
| Duration | Wait time between the time the lock request was issued and the time the lock was released. | |
| Object ID | ID of the object on which the lock was timed out. | |
| Index ID | ID of the index, if the object lock was on an index. |