Red Gate forums :: View topic - Long-running query SQL process fragment Unknown
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Monitor 3
SQL Monitor 3 forum

Long-running query SQL process fragment Unknown

Search in SQL Monitor 3 forum
Post new topic   Reply to topic
Jump to:  
Author Message
fifthrace



Joined: 08 Jun 2012
Posts: 12
Location: Indianapolis, IN

PostPosted: Fri Jun 08, 2012 5:53 pm    Post subject: Long-running query SQL process fragment Unknown Reply with quote

Since upgrading to 3.1, I've noticed that on the Long-running query alert my SQL process fragment is no longer showing as it did before in the UI.

I apologize if I missed something that stated why this would be. Any help would be much appreciated.

Thanks all,

Robbie
Back to top
View user's profile Send private message
Chris Spencer



Joined: 29 Aug 2006
Posts: 301
Location: Red Gate - Cambridge

PostPosted: Mon Jun 11, 2012 11:36 am    Post subject: Reply with quote

Apologies but this is a regression in SQL Monitor v3.1.

A bug has been raised (ref: SRP-6952) and we'll be looking to fix this for the next release.

Regards
Chris
_________________
Chris Spencer
Test Engineer
Red Gate
Back to top
View user's profile Send private message
EdCarden



Joined: 25 Nov 2008
Posts: 88

PostPosted: Tue Jul 17, 2012 4:35 pm    Post subject: What if we downgrade back to 3.0.x Reply with quote

What if we downgrade back to the prior version of 3.0.X we were using, can we get back the misssing SQL Fragment info?

I hope this bug has been given a high level of priorty because the LRQ (long Running Query) alert is just about useless without this key piece of information.

I'm suprised that this is not being fixed till the next release of SQL Monitor. Then again maybe no other user besides myself makes use of the LRQ alert and so this is not a major setback/bug for anyone else.

Thanks
Back to top
View user's profile Send private message
Chris Spencer



Joined: 29 Aug 2006
Posts: 301
Location: Red Gate - Cambridge

PostPosted: Tue Jul 17, 2012 5:23 pm    Post subject: Reply with quote

This issue is fixed internally but we're still in the process of scheduling our next release. I'll speak to some people and if possible get back to you with an estimated release date.

Downgrading to 3.0 would get the SQL Fragment info back but I'm not sure if the v3.0 software would work with a v3.1 data repository. I'd have to test that.

Regards
Chris
_________________
Chris Spencer
Test Engineer
Red Gate
Back to top
View user's profile Send private message
EdCarden



Joined: 25 Nov 2008
Posts: 88

PostPosted: Tue Jul 17, 2012 10:00 pm    Post subject: Reply with quote

Chris,

FYI - So far the downgrade is working. I have yet to have any probelms or errors and most importanty, I got back my missing SQL Fragment info for LRQ alerts.

I was worried that the info had been permanently lost and not just missing but its still there. I just wish I knew how to get that info directly from the DB.

Thanks
Back to top
View user's profile Send private message
Chris Spencer



Joined: 29 Aug 2006
Posts: 301
Location: Red Gate - Cambridge

PostPosted: Wed Jul 18, 2012 1:59 pm    Post subject: Reply with quote

That's good to know that a downgrade appears to work.

Regarding getting the information out of the repository, I've had a little go at doing this and come up with:

Code:
USE RedGateMonitor -- or whatever the repository name is
GO
SELECT utils.TicksToDateTime(us.CollectionDate) AS CollectionTime           
      ,us._Command
      ,us._CumulativeProcessorTime
      ,us._DatabaseName     
      ,us._FullCommand     
      ,us._Status     
  FROM [data].[Cluster_SqlServer_SqlProcess_UnstableSamples] us
  JOIN [data].[Cluster_SqlServer_SqlProcess_Keys] spk
  ON us.Id = spk.Id
  WHERE spk.[_SessionId] = 99 -- replace this value with Process ID from the alert details page. 
  ORDER BY CollectionTime DESC


I think that this at least maps SQL fragments to Process IDs.

Regards
Chris
_________________
Chris Spencer
Test Engineer
Red Gate
Back to top
View user's profile Send private message
Saint007



Joined: 30 Jul 2012
Posts: 1

PostPosted: Mon Jul 30, 2012 7:40 am    Post subject: Reply with quote

I got the same problem. Let me know when this issue is fixed and release.
Back to top
View user's profile Send private message
JKG



Joined: 13 Apr 2012
Posts: 2

PostPosted: Mon Jul 30, 2012 2:56 pm    Post subject: Same Issue..... Reply with quote

Can we get an estimated date for the fix availability. I use this frequently and need to decide about rolling back.
Back to top
View user's profile Send private message
Chris Spencer



Joined: 29 Aug 2006
Posts: 301
Location: Red Gate - Cambridge

PostPosted: Mon Jul 30, 2012 3:28 pm    Post subject: Reply with quote

We're planning to release SQL Monitor 3.2 next week, most probably on the Tuesday or Wednesday (August 7-8). This will contain the LRQ fix.

I think that this is a fairly safe estimate but if it changes I'll post an update.

Regards
Chris
_________________
Chris Spencer
Test Engineer
Red Gate
Back to top
View user's profile Send private message
Chris Spencer



Joined: 29 Aug 2006
Posts: 301
Location: Red Gate - Cambridge

PostPosted: Tue Aug 07, 2012 4:08 pm    Post subject: Reply with quote

Just to let you all know, v3.2 has been released and can be downloaded from:
http://www.red-gate.com/sqlmonitor

This release fixes the LRQ alert issue.

Regards
Chris
_________________
Chris Spencer
Test Engineer
Red Gate
Back to top
View user's profile Send private message
fifthrace



Joined: 08 Jun 2012
Posts: 12
Location: Indianapolis, IN

PostPosted: Wed Aug 08, 2012 7:23 pm    Post subject: Working Now Reply with quote

Thanks Chris, seems to be working better now.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic 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