Red Gate forums :: View topic - Downgrade to SQL Monitor 2.3
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

Downgrade to SQL Monitor 2.3

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



Joined: 18 Jul 2012
Posts: 3

PostPosted: Thu Jul 19, 2012 9:16 am    Post subject: Downgrade to SQL Monitor 2.3 Reply with quote

I recently upgraded from version 2.3 to version 3.1 after attending SQL in the City as wanted to take advantage of custom metrics functionality.

However, since I upgraded to 3.1 the long-running query does not return the SQL fragment information any longer. Apparently this is a bug for version 3; so now I would like to go back to version 2.3 until this is fixed in next release, however, support are telling me they wouldn't advise downgrade as unsure what will happen to the repository if I do so.

Anybody got any ideas or experience of having to do this due to bugs in version 3??

Thanks,

Gavin
Back to top
View user's profile Send private message
chriskelly



Joined: 19 Apr 2010
Posts: 330
Location: Cambridge, UK

PostPosted: Fri Jul 20, 2012 5:25 pm    Post subject: Reply with quote

The main problem with downgrading to version 2.3 is that the data repository schema has changed massively for v3 (mainly to accommodate the custom metric functionality). This means that to use v2.3 you would need to create a brand new database with the old schema, therefore losing access to any data you have in the current data repository.

Version 3.2 should be available in just over a weeks time, so this may be a lot of work for only 7-14 days of benefit.
_________________
Chris Kelly
Technical Support Engineer
Back to top
View user's profile Send private message
gsmith151



Joined: 18 Jul 2012
Posts: 3

PostPosted: Mon Jul 23, 2012 8:09 am    Post subject: Downgrade to SQL Monitor 2.3 Reply with quote

Chris,

I've managed to downgrade to version 3.0 and it seems to be working OK so far so I'll stick with this version for the time being.

Thanks for the reply!
Back to top
View user's profile Send private message
Chris Spencer



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

PostPosted: Mon Aug 13, 2012 4:38 pm    Post subject: Reply with quote

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

This fixes the LRQ alert bug.

Regards
Chris
_________________
Chris Spencer
Test Engineer
Red Gate
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