Database displayed as Offline

SQL Server performance monitoring and alerting

Moderators: Colin Millerchip, priyasinha, Adam, chriskelly

Database displayed as Offline

Postby kmonroe@psecu.com » Tue Jan 21, 2014 1:31 pm

I have an instance that I'm monitoring that has 45 databases. Two of the databases are displaying "Offline" in SQL Monitor but in SQL Server they are online.

Any Ideas??

Kevin
Kevin Monroe
SQL Server DBA
kmonroe@psecu.com
 
Posts: 5
Joined: Thu Dec 06, 2012 7:34 pm
Location: Pennsylvania, US

Postby chriskelly » Wed Jan 22, 2014 9:11 pm

Simply restart the SQL Server service. This will reset the configuration flag which SQL Monitor uses to determine the state of the databases.
Chris Kelly
Technical Support Engineer
chriskelly
 
Posts: 330
Joined: Mon Apr 19, 2010 1:44 pm
Location: Cambridge, UK

Postby kmonroe@psecu.com » Wed Jan 22, 2014 9:35 pm

Thanks for the Reply Chris. So SQL Monitor doesn't periodically recheck to see if the database is back online after being marked as offline?

I know that it repeatedly checks to see if the state changes from online to anything other than online. I've seen the database unavailable alert when performing a restore or if SQL monitor checks a SQL Server after a restart before all of the databases have gone through crash recovery.

Either way, that is good to know. I'll have to remember to recheck the instance in SQL Monitor the next time the instance is restarted.

Thanks again,
Kevin
Kevin Monroe
SQL Server DBA
kmonroe@psecu.com
 
Posts: 5
Joined: Thu Dec 06, 2012 7:34 pm
Location: Pennsylvania, US

Postby chriskelly » Wed Jan 22, 2014 10:04 pm

It does periodically check the status of the database. But there are some scenarios where the status flag that SQL Monitor uses for this check does not get correctly updated in SQL Server. I'm not sure why this happens, but restarting the SQL Server service seems to force this to be correctly updated. This means that the next time that it is checked, it is correct.
Chris Kelly
Technical Support Engineer
chriskelly
 
Posts: 330
Joined: Mon Apr 19, 2010 1:44 pm
Location: Cambridge, UK


Return to SQL Monitor 4

Who is online

Users browsing this forum: No registered users and 0 guests