Export (0) Print
Expand All

Locks Data Columns

SQL Server 2000

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.

See Also

Locking

Locks Event Category

Locks Event Classes

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft