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:
shows what I would like to see, so there must be a way.
, , "SQL: StatementStarting", , SPID, . , SQL Profiler -, SQL . , , , , , , .
, , SQL Server - , , , .
Source: https://habr.com/ru/post/1726426/More articles:Масштабирование и производительность Couch DB - couchdbHow can I check for failure in constructor () without using exceptions? - c ++Stop service when uninstalling on Win 7 from UAC from WIX - installerКак получить ANTLR для вывода иерархических АСТ? - luaAutomated regression tests for Java applets? - appletnhibernate Dynamic Insert terminates with some null component properties - nhibernateBrowse With ... option not available in ASP.Net MVC Project - debuggingHow to make Android apps compatible with different screen resolutions? - androidHow to show controls in a fixed position for different screen resolutions in Android? - androidThousands of rays intersect with triangles in three-dimensional space - mathAll Articles