Show "HostPID" on deadlocks
Add "Hostname" and "Hostpid" detail to blocking processes and long running queries in RedGate, this information is available deadlocks.
This would help us to identify the process causing the blocking to further investigate fixes vs trying to work out the process from the SQL code, which can often look similar to other queries.
2
votes
Chris Johnson
shared this idea
-
Greg Smulko (Redgate)
commented
Hey Chris, could you please expand on what exactly you would like to see?
I see that we have already the following in the UI:
- for deadlock there is `Host name`,
- for Long-running query there is `Host` in the Details tab and
- for Blocking process there is `Host` in the Processes tab.Do I understand correctly that you'd like to see "hostpid" in addition to Host name for the above, or is there anything else?