question

JoeBx avatar image
JoeBx asked

SQL Profiler 2008 Deadlock Graph ToolTip Not Showing SQL

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. Do you know why? Is there a workaround?
deadlock
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ThomasRushton avatar image
ThomasRushton answered
Is the data (sorry, query) there if you look in the .XDL file itself? Just open it up in Notepad or a proper text editor and have a look...
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Bit avatar image
Bit answered

When it says "statement proc" it refers to a stored procedure. You should see also a "database id" and "object id" (for example, 1460916255). You can find the name of the stored procedure by running SELECT OBJECT_NAME(1460916255). Huge efforts to develop such a strong ad complex component, and you need tu run a query more to reach the name of a stored procedure... absurd.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.