Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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?

like image 833
Jacques Avatar asked Oct 11 '22 03:10

Jacques


1 Answers

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.

like image 160
Martin Smith Avatar answered Oct 13 '22 10:10

Martin Smith