How to resolve linenumber in deadlock graph XML to line number displayed in SSMS sproc definition?
2
votes
1
answer
162
views
Captured the XML graph for a given deadlock involving some large / multi query sp's. However, not really sure how to interpret the line, stmtstart, stmtend of the frame element to determine which line of sproc TSQL encountered the deadlock. Line 214 doesn't seem to line up with any query in the SSMS editor but I am not sure how the engine normalizes sproc TSQL when line numbering. How do you resolve the captured line number with the line number as displayed in SSMS sproc definition?
exec sp_executesql @NSQL, N'@ARG1 int', @ARG1 = @MyArg1
Asked by user2368632
(1133 rep)
Nov 18, 2022, 04:59 PM
Last activity: Nov 21, 2022, 11:39 AM
Last activity: Nov 21, 2022, 11:39 AM