This element shows the level of nesting or recursion in effect when the statement was being run; each level of nesting corresponds to nested or recursive invocation of a stored procedure or user-defined function (UDF).
Table Function | Monitor Element Collection Level |
---|---|
MON_GET_ACTIVITY_DETAILS table function - Get complete activity details (reported in DETAILS XML document) | Always collected |
Event Type | Logical Data Grouping | Monitor Switch |
---|---|---|
Locking | - | - |
Deadlocks with Details History Values1 | event_stmt_history | - |
Deadlocks with Details History1 | event_stmt_history | - |
Activities | event_activitystmt | - |
Unit of work | Reported in the package list. | - |
You can use this element, along with stmt_invocation_id monitor element, to uniquely identify the invocation in which a particular SQL statement has been executed. You can also use this element in conjunction with other statement history entries to see the sequence of SQL statements that caused the deadlock.