Downgrade to SQL Monitor 2.3

SQL Server performance monitoring and alerting

Moderators: eddie davis, priyasinha, Adam, chriskelly, Chris Lambrou, Chris Spencer

Downgrade to SQL Monitor 2.3

Postby gsmith151 » Thu Jul 19, 2012 9:16 am

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
gsmith151
 
Posts: 3
Joined: Wed Jul 18, 2012 4:57 pm

Postby chriskelly » Fri Jul 20, 2012 5:25 pm

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
chriskelly
 
Posts: 330
Joined: Mon Apr 19, 2010 1:44 pm
Location: Cambridge, UK

Downgrade to SQL Monitor 2.3

Postby gsmith151 » Mon Jul 23, 2012 8:09 am

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!
gsmith151
 
Posts: 3
Joined: Wed Jul 18, 2012 4:57 pm

Postby Chris Spencer » Mon Aug 13, 2012 4:38 pm

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
Chris Spencer
 
Posts: 301
Joined: Tue Aug 29, 2006 9:09 am
Location: Red Gate - Cambridge


Return to SQL Monitor 3

Who is online

Users browsing this forum: No registered users and 0 guests