Databases shown as offline

SQL Server performance monitoring and alerting

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

Databases shown as offline

Postby jonwilk » Fri May 27, 2011 8:32 am

Hi

Just upgraded to 2.3

We're monitoring a few servers and all is well, however, the 1 and only cluster we're monitornig is showing the databases as offline when viewed from the overview page.

The status shows as OK (on the overview page), the status on the configuration>monitored servers is showing as Monitoring/Connected, and the monitoring show log is clear and highlighted in green.

Not sure what to check to get them shown as online in this page (everything else seems ok - ie alerts etc)

Happy to post a screen shot if it helps

Thanks
jonwilk
 
Posts: 18
Joined: Fri Sep 09, 2005 3:25 pm

Postby priyasinha » Fri May 27, 2011 11:56 am

Hi Jon,

Could you login to this instance via SSMS (SQL Server Management Studio) and connect to this particular instance and verify if the databse listed in Overview is actually offline or not?

Thanks,
Priya
priyasinha
 
Posts: 532
Joined: Wed Jan 03, 2007 5:02 pm

Postby jonwilk » Fri May 27, 2011 12:06 pm

hi
all of the databases are online and working fine (this is a production server)
they are all showing as offline in sql monitor
this worked fine in 2.2
thanks
jonwilk
 
Posts: 18
Joined: Fri Sep 09, 2005 3:25 pm

Postby priyasinha » Fri May 27, 2011 12:31 pm

Hi Jon,

Could you please email a screen shot of Overview page and SSMS (showing the database) to priya.sinha@red-gate.com?

Thanks,
Priya
priyasinha
 
Posts: 532
Joined: Wed Jan 03, 2007 5:02 pm

Databases shown as offline

Postby gmjones » Wed Mar 07, 2012 7:53 pm

Having the exact same problem. Monitoring a SQL 2008 instance, all databases are showing offline. Still collecting data though.
gmjones
 
Posts: 2
Joined: Wed Mar 07, 2012 7:44 pm

Postby fionag » Mon Mar 12, 2012 10:46 am

gmjones - Would you be able to email through your log files to fiona.gazeley@red-gate.com
The following article explains how to get your log files.
http://www.red-gate.com/supportcenter/c ... LogFilesKB
Many thanks
Fiona
fionag
 
Posts: 34
Joined: Thu Jan 05, 2012 5:40 pm
Location: Red Gate

Databases shown as offline

Postby gmjones » Mon Mar 12, 2012 1:22 pm

Fiona, thanks for the followup. This was a new install, and the error automagically cleared up after a couple of hours. Support already has the log files for research, and has flagged the ticket as inactive.
gmjones
 
Posts: 2
Joined: Wed Mar 07, 2012 7:44 pm


Return to SQL Monitor 2

Who is online

Users browsing this forum: No registered users and 0 guests