Process ID not found in Performance Snapshot
xexex
Posts: 56
I'm using SQL Response 1.3 and SQL 2000 Ent. We've noted that when we open the details of SQL deadlock/ Long running query, I can't find the Process ID in Performance Snapshot that shown in Deadlock/ SQL Process Details. For example:
I see Process ID 377 show in Long running query, the SQL query fragment is "exec sp_trace_getdata 1, 0", I want to know the detail of the process so I will go to the Performance Snapshot to see the detail. However, I can't found the Process ID in Performance Snapshot.
Why is the ID not shown at snapshot, and how can I know the detail of long running querry, such as which statement should be rewrite.
I see Process ID 377 show in Long running query, the SQL query fragment is "exec sp_trace_getdata 1, 0", I want to know the detail of the process so I will go to the Performance Snapshot to see the detail. However, I can't found the Process ID in Performance Snapshot.
Why is the ID not shown at snapshot, and how can I know the detail of long running querry, such as which statement should be rewrite.
Comments
I am not entirely sure that I understand the issue that you are experiencing. Please would you be able to send some screenshots to support(at)red-gate.com that demonstrate what you are experiencing, quoting reference number F0037793 in the subject line.
Many thanks!
Pete
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569
I've sent the E-mail to suppotATred-gate.com with screenshot
Hi, Regdate Support.
I've sent 2 E-mail to you but I haven't received your reply yet.
Does this issue can be fixed in V1?
I believe we have answered this off the forums, however if that isn't the case please do let me know.
Pete
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569