The Lock event category has the following event class:
Event ID
Event Name
Event Description
50
Deadlock
Information on current locks in deadlock state.
51
Lock Timeout
Information on locks that had recently timed out
52
Lock Acquired
Information on recently acquired locks
53
Lock Released
Information on recently released locks
54
Lock Waiting
Information on locks waiting on other locks
The following table lists the data columns for this event class.
Deadlock
Column Name
Column Id
Column Type
Column Description
EventClass
0
1
Event Class is used to categorize events.
CurrentTime
2
5
Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
DatabaseName
28
8
Name of the database in which the statement of the user is running.
TextData
42
9
Text data associated with the event.
ServerName
43
8
Name of the server producing the event.
Lock Timeout
Column Name
Column Id
Column Type
Column Description
EventClass
0
1
Event Class is used to categorize events.
CurrentTime
2
5
Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
StartTime
3
5
Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
EndTime
4
5
Time 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'.
Duration
5
2
Amount of time (in milliseconds) taken by the event.
IntegerData
10
1
Integer data.
ObjectType
12
1
Object type.
ObjectPath
14
8
Object path. A comma-separated list of parents, starting with the object's parent.
ConnectionID
25
1
Unique connection ID.
DatabaseName
28
8
Name of the database in which the statement of the user is running.
NTUserName
32
8
Contains the user name associated with the command event. Depending on the environment, the user name is in the following form: - Windows user account (DOMAIN\UserName) - User Principal Name (UPN) (username@domain.com) - Service Principal Name (SPN) (appid@tenantid) - Power BI Service Account (Power BI Service) - Power BI Service on behalf of a UPN or SPN (Power BI Service (UPN/SPN))
NTDomainName
33
8
Contains the domain name associated with the user account that triggered the command event. - Windows domain name for Windows user accounts - AzureAD for Microsoft Entra accounts - NT AUTHORITY accounts without a Windows domain name, such as the Power BI service
SessionID
39
8
Session GUID.
NTCanonicalUserName
40
8
Contains the user name associated with the command event. Depending on the environment, the user name is in the following form: - Windows user account (DOMAIN\UserName) - User Principal Name (UPN) (username@domain.com) - Service Principal Name (SPN) (appid@tenantid) - Power BI Service Account (Power BI Service)
SPID
41
1
Server process ID. This uniquely identifies a user session. This directly corresponds to the session GUID used by XML/A.
ServerName
43
8
Name of the server producing the event.
Lock Acquired
Column Name
Column Id
Column Type
Column Description
EventClass
0
1
Event Class is used to categorize events.
CurrentTime
2
5
Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
ConnectionID
25
1
Unique connection ID.
NTUserName
32
8
Contains the user name associated with the command event. Depending on the environment, the user name is in the following form: - Windows user account (DOMAIN\UserName) - User Principal Name (UPN) (username@domain.com) - Service Principal Name (SPN) (appid@tenantid) - Power BI Service Account (Power BI Service) - Power BI Service on behalf of a UPN or SPN (Power BI Service (UPN/SPN))
NTDomainName
33
8
Contains the domain name associated with the user account that triggered the command event. - Windows domain name for Windows user accounts - AzureAD for Microsoft Entra accounts - NT AUTHORITY accounts without a Windows domain name, such as the Power BI service
ClientHostName
35
8
Name of the computer on which the client is running. This data column is populated if the host name is provided by the client.
ClientProcessID
36
1
The process ID of the client application.
ApplicationName
37
8
Name 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.
SessionID
39
8
Session GUID.
NTCanonicalUserName
40
8
Contains the user name associated with the command event. Depending on the environment, the user name is in the following form: - Windows user account (DOMAIN\UserName) - User Principal Name (UPN) (username@domain.com) - Service Principal Name (SPN) (appid@tenantid) - Power BI Service Account (Power BI Service)
SPID
41
1
Server process ID. This uniquely identifies a user session. This directly corresponds to the session GUID used by XML/A.
TextData
42
9
Text data associated with the event.
ServerName
43
8
Name of the server producing the event.
Lock Released
Column Name
Column Id
Column Type
Column Description
EventClass
0
1
Event Class is used to categorize events.
CurrentTime
2
5
Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
ConnectionID
25
1
Unique connection ID.
NTUserName
32
8
Contains the user name associated with the command event. Depending on the environment, the user name is in the following form: - Windows user account (DOMAIN\UserName) - User Principal Name (UPN) (username@domain.com) - Service Principal Name (SPN) (appid@tenantid) - Power BI Service Account (Power BI Service) - Power BI Service on behalf of a UPN or SPN (Power BI Service (UPN/SPN))
NTDomainName
33
8
Contains the domain name associated with the user account that triggered the command event. - Windows domain name for Windows user accounts - AzureAD for Microsoft Entra accounts - NT AUTHORITY accounts without a Windows domain name, such as the Power BI service
ClientHostName
35
8
Name of the computer on which the client is running. This data column is populated if the host name is provided by the client.
ClientProcessID
36
1
The process ID of the client application.
ApplicationName
37
8
Name 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.
SessionID
39
8
Session GUID.
NTCanonicalUserName
40
8
Contains the user name associated with the command event. Depending on the environment, the user name is in the following form: - Windows user account (DOMAIN\UserName) - User Principal Name (UPN) (username@domain.com) - Service Principal Name (SPN) (appid@tenantid) - Power BI Service Account (Power BI Service)
SPID
41
1
Server process ID. This uniquely identifies a user session. This directly corresponds to the session GUID used by XML/A.
TextData
42
9
Text data associated with the event.
ServerName
43
8
Name of the server producing the event.
Lock Waiting
Column Name
Column Id
Column Type
Column Description
EventClass
0
1
Event Class is used to categorize events.
CurrentTime
2
5
Time at which the event started, when available. For filtering, expected formats are 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'.
ConnectionID
25
1
Unique connection ID.
NTUserName
32
8
Contains the user name associated with the command event. Depending on the environment, the user name is in the following form: - Windows user account (DOMAIN\UserName) - User Principal Name (UPN) (username@domain.com) - Service Principal Name (SPN) (appid@tenantid) - Power BI Service Account (Power BI Service) - Power BI Service on behalf of a UPN or SPN (Power BI Service (UPN/SPN))
NTDomainName
33
8
Contains the domain name associated with the user account that triggered the command event. - Windows domain name for Windows user accounts - AzureAD for Microsoft Entra accounts - NT AUTHORITY accounts without a Windows domain name, such as the Power BI service
ClientHostName
35
8
Name of the computer on which the client is running. This data column is populated if the host name is provided by the client.
ClientProcessID
36
1
The process ID of the client application.
ApplicationName
37
8
Name 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.
SessionID
39
8
Session GUID.
NTCanonicalUserName
40
8
Contains the user name associated with the command event. Depending on the environment, the user name is in the following form: - Windows user account (DOMAIN\UserName) - User Principal Name (UPN) (username@domain.com) - Service Principal Name (SPN) (appid@tenantid) - Power BI Service Account (Power BI Service)
SPID
41
1
Server process ID. This uniquely identifies a user session. This directly corresponds to the session GUID used by XML/A.
TextData
42
9
Text data associated with the event.
ServerName
43
8
Name of the server producing the event.
Feedback
Was this page helpful?
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.