| Author |
Message |
xexex
Joined: 24 Jun 2010 Posts: 31
|
Posted: Fri Aug 13, 2010 4:03 am Post subject: Process ID not found in Performance Snapshot |
|
|
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. |
|
| Back to top |
|
 |
peter.peartSite Admin
Joined: 02 Sep 2008 Posts: 362 Location: Top floor, RG towers with the cool kids
|
Posted: Mon Aug 16, 2010 5:05 pm Post subject: |
|
|
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 |
|
| Back to top |
|
 |
xexex
Joined: 24 Jun 2010 Posts: 31
|
Posted: Wed Aug 18, 2010 5:54 am Post subject: |
|
|
Thanks for your reply.
I've sent the E-mail to suppotATred-gate.com with screenshot |
|
| Back to top |
|
 |
xexex
Joined: 24 Jun 2010 Posts: 31
|
Posted: Tue Sep 14, 2010 3:45 am Post subject: Re: |
|
|
| 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? |
|
| Back to top |
|
 |
peter.peartSite Admin
Joined: 02 Sep 2008 Posts: 362 Location: Top floor, RG towers with the cool kids
|
Posted: Mon Sep 20, 2010 1:20 pm Post subject: |
|
|
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 |
|
| Back to top |
|
 |
|
|
All times are GMT + 1 Hour
|
| Page 1 of 1 |
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
Powered by phpBB © 2001, 2005 phpBB Group