CODEWITHSUNDEEP
sqlsql-serversql-server-2008sql-server-profiler
Jacques
Jacques

Reputation: 746

SQL Profiler 2008 Deadlock Graph ToolTip Not Showing actual statements

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?

Upvotes: 5

Views: 989

Answers (1)

Martin Smith
Martin Smith

Reputation: 453707

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.

Upvotes: 4

Related Questions