Downgrade to SQL Monitor 2.3

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

Downgrade to SQL Monitor 2.3

Postby gsmith151 » Thu Jul 19, 2012 8: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??


Posts: 3
Joined: Wed Jul 18, 2012 3:57 pm

Postby chriskelly » Fri Jul 20, 2012 4: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
Posts: 368
Joined: Mon Apr 19, 2010 12:44 pm
Location: Cambridge, UK

Downgrade to SQL Monitor 2.3

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


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

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

Just to let you know, v3.2 has been released and can be downloaded from:

This fixes the LRQ alert bug.

Chris Spencer
Test Engineer
Red Gate
Chris Spencer
Posts: 301
Joined: Tue Aug 29, 2006 8:09 am
Location: Red Gate - Cambridge

Return to SQL Monitor Previous Versions

Who is online

Users browsing this forum: Google [Bot] and 0 guests