SQL Server Profiler: how can I display query parameter values ​​in a deadlock column?

I'm trying to debug a deadlock using SQL Server Profiler 2008. I know how to get a deadlock graph in the profiler, but when I hovered over one of the two statements shown in the graph, the "Statement" tooltip "contains only a query with parameter names, and not meanings.

In other words, I get hints like this:

DELETE FROM users WHERE id = @id

How can I see the corresponding parameter values? This screenshot:

enter image description here shows what I would like to see, so there must be a way.

+3
source share
1 answer

, , "SQL: StatementStarting", , SPID, . , SQL Profiler -, SQL . , , , , , , .

, , SQL Server - , , , .

+2

Source: https://habr.com/ru/post/1726426/


All Articles