Database displayed as Offline

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

Database displayed as Offline

Postby kmonroe@psecu.com » Tue Jan 21, 2014 12: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 6:34 pm
Location: Pennsylvania, US

Postby chriskelly » Wed Jan 22, 2014 8: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.
chriskelly
 
Posts: 373
Joined: Mon Apr 19, 2010 12:44 pm
Location: Cambridge, UK

Postby kmonroe@psecu.com » Wed Jan 22, 2014 8: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 6:34 pm
Location: Pennsylvania, US

Postby chriskelly » Wed Jan 22, 2014 9: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.
chriskelly
 
Posts: 373
Joined: Mon Apr 19, 2010 12:44 pm
Location: Cambridge, UK


Return to SQL Monitor Previous Versions

Who is online

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