TechNet
Export (0) Print
Expand All

Lock Events Data Columns

 

Applies To: SQL Server 2016

The Lock event category has the following event class:

Event IDEvent NameEvent Description
50DeadlockInformation on current locks in deadlock state.
51Lock TimeoutInformation on locks that had recently timed out
52Lock AcquiredInformation on recently acquired locks
53Lock ReleasedInformation on recently released locks
54Lock WaitingInformation on locks waiting on other locks

The following table lists the data columns for this event class.

Column NameColumn IdColumn TypeColumn Description
EventClass01Event Class is used to categorize events.
CurrentTime25Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
DatabaseName288Name of the database in which the statement of the user is running.
TextData429Text data associated with the event.
ServerName438Name of the server producing the event.
Column NameColumn IdColumn TypeColumn Description
EventClass01Event Class is used to categorize events.
CurrentTime25Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
StartTime35Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
EndTime45Time at which the event ended. This column is not populated for starting event classes, such as SQL:BatchStarting or SP:Starting. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
Duration52Amount of time (in milliseconds) taken by the event.
IntegerData101Integer data.
ObjectType121Object type.
ObjectPath148Object path. A comma-separated list of parents, starting with the object's parent.
ConnectionID251Unique connection ID.
DatabaseName288Name of the database in which the statement of the user is running.
NTUserName328Windows user name.
NTDomainName338Windows domain to which the user belongs.
SessionID398Session GUID.
NTCanonicalUserName408User name in canonical form. For example, engineering.microsoft.com/software/someone.
SPID411Server process ID. This uniquely identifies a user session. This directly corresponds to the session GUID used by XML/A.
ServerName438Name of the server producing the event.
Column NameColumn IdColumn TypeColumn Description
EventClass01Event Class is used to categorize events.
CurrentTime25Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
ConnectionID251Unique connection ID.
NTUserName328Windows user name.
NTDomainName338Windows domain to which the user belongs.
ClientHostName358Name of the computer on which the client is running. This data column is populated if the host name is provided by the client.
ClientProcessID361The process ID of the client application.
ApplicationName378Name of the client application that created the connection to the server. This column is populated with the values passed by the application rather than the displayed name of the program.
SessionID398Session GUID.
NTCanonicalUserName408User name in canonical form. For example, engineering.microsoft.com/software/someone.
SPID411Server process ID. This uniquely identifies a user session. This directly corresponds to the session GUID used by XML/A.
TextData429Text data associated with the event.
ServerName438Name of the server producing the event.
Column NameColumn IdColumn TypeColumn Description
EventClass01Event Class is used to categorize events.
CurrentTime25Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
ConnectionID251Unique connection ID.
NTUserName328Windows user name.
NTDomainName338Windows domain to which the user belongs.
ClientHostName358Name of the computer on which the client is running. This data column is populated if the host name is provided by the client.
ClientProcessID361The process ID of the client application.
ApplicationName378Name of the client application that created the connection to the server. This column is populated with the values passed by the application rather than the displayed name of the program.
SessionID398Session GUID.
NTCanonicalUserName408User name in canonical form. For example, engineering.microsoft.com/software/someone.
SPID411Server process ID. This uniquely identifies a user session. This directly corresponds to the session GUID used by XML/A.
TextData429Text data associated with the event.
ServerName438Name of the server producing the event.
Column NameColumn IdColumn TypeColumn Description
EventClass01Event Class is used to categorize events.
CurrentTime25Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
ConnectionID251Unique connection ID.
NTUserName328Windows user name.
NTDomainName338Windows domain to which the user belongs.
ClientHostName358Name of the computer on which the client is running. This data column is populated if the host name is provided by the client.
ClientProcessID361The process ID of the client application.
ApplicationName378Name of the client application that created the connection to the server. This column is populated with the values passed by the application rather than the displayed name of the program.
SessionID398Session GUID.
NTCanonicalUserName408User name in canonical form. For example, engineering.microsoft.com/software/someone.
SPID411Server process ID. This uniquely identifies a user session. This directly corresponds to the session GUID used by XML/A.
TextData429Text data associated with the event.
ServerName438Name of the server producing the event.

Lock Events Category

Community Additions

ADD
Show:
© 2016 Microsoft