Process ID not found in Performance Snapshot

Monitor, diagnose and receive alerts to problems across your SQL Servers.

Moderators: eddie davis, david connell, dlkj, Colin Millerchip, priyasinha, Emma A

Process ID not found in Performance Snapshot

Postby xexex » Fri Aug 13, 2010 4:03 am

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.
xexex
 
Posts: 41
Joined: Thu Jun 24, 2010 5:50 am

Postby peter.peart » Mon Aug 16, 2010 5:05 pm

Hi there,

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
Peter Peart
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569
peter.peart
Site Admin
 
Posts: 362
Joined: Tue Sep 02, 2008 9:58 am
Location: Top floor, RG towers with the cool kids

Postby xexex » Wed Aug 18, 2010 5:54 am

Thanks for your reply.
I've sent the E-mail to suppotATred-gate.com with screenshot
xexex
 
Posts: 41
Joined: Thu Jun 24, 2010 5:50 am

Re:

Postby xexex » Tue Sep 14, 2010 3:45 am

xexex wrote:Thanks for your reply.
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?
xexex
 
Posts: 41
Joined: Thu Jun 24, 2010 5:50 am

Postby peter.peart » Mon Sep 20, 2010 1:20 pm

Hi there,

I believe we have answered this off the forums, however if that isn't the case please do let me know.

Pete
Peter Peart
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569
peter.peart
Site Admin
 
Posts: 362
Joined: Tue Sep 02, 2008 9:58 am
Location: Top floor, RG towers with the cool kids


Return to SQL Response 1

Who is online

Users browsing this forum: No registered users and 0 guests