In a deadlock graph, hovering over the deadlock ovals should produce the SQL statement. However, in SQL Profiler 2008, the ToolTip is either showing "Statement" or "Statement Proc" and not the statement itself. Does anyone ? Is there a workaround?
Asked
Active
Viewed 977 times
5
Martin Smith
- 438,706
- 87
- 741
- 845
Jacques
- 747
- 1
- 8
- 19
-
2Does the raw XML contain the statements? (Use the "Extract Event Data" to save as XML) – Martin Smith Aug 31 '11 at 19:08
-
Is your trace also collecting StmtCompleted events? This article has a good primer: http://www.simple-talk.com/sql/learn-sql-server/how-to-track-down-deadlocks-using-sql-server-2005-profiler/ – Aaron Bertrand Aug 31 '11 at 19:19
-
1Do you run encrypted procedures, or does your batch contain passwords? – Remus Rusanu Aug 31 '11 at 20:17
-
@Martin - I will try that and report back – Jacques Sep 01 '11 at 05:53
-
@Aaron - Unfortunately I need to catch this in a production environment so switching on StmtCompleted will flood my profiler. – Jacques Sep 01 '11 at 05:54
-
@Martin. kudos for you. That worked. Please submit that as an answer so I can mark it. – Jacques Sep 01 '11 at 09:04
1 Answers
4
Not sure why these wouldn't show up in the graphic itself. Perhaps worth reporting as a bug on Microsoft Connect.
As a workaround you could try using the "Extract Event Data" option to save as XML and look for them there.
Martin Smith
- 438,706
- 87
- 741
- 845