Export (0) Print
Expand All

Lock Events Data Columns

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.

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.

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

Windows user name.

NTDomainName

33

8

Windows domain to which the user belongs.

SessionID

39

8

Session GUID.

NTCanonicalUserName

40

8

User name in canonical form. For example, engineering.microsoft.com/software/someone.

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.

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

Windows user name.

NTDomainName

33

8

Windows domain to which the user belongs.

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

User name in canonical form. For example, engineering.microsoft.com/software/someone.

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.

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

Windows user name.

NTDomainName

33

8

Windows domain to which the user belongs.

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

User name in canonical form. For example, engineering.microsoft.com/software/someone.

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.

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

Windows user name.

NTDomainName

33

8

Windows domain to which the user belongs.

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

User name in canonical form. For example, engineering.microsoft.com/software/someone.

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.

Community Additions

ADD
Show:
© 2014 Microsoft