Failure to detect/notify server offline

SQL Server performance monitoring and alerting

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

Failure to detect/notify server offline

Postby mark_anderson_us » Tue Jun 19, 2012 2:50 pm

Hi All

We had a problem with out SQL server last night. The SQL server was offline (connections to it failed) from about 2:45am. I had a lot of messages about prior to this about long running queries, blocked processes, etc. but nothing to tell me the server was offline. All the analysis graphs show nothing from 2:45 until restart theis morning.

Should I get notified if the server is unreachable. Ideally I want text messages on such an event.

Regards

Mark
mark_anderson_us
 
Posts: 23
Joined: Sat Apr 28, 2012 8:27 pm

Postby Chris Spencer » Tue Jun 19, 2012 5:12 pm

Hi Mark

Yes you should definitely be getting an alert if the server becomes unreachable for some reason.

I'm assuming that SQL Monitor's data repository is not located on the server that went offline?

Also which version of SQL Monitor are you currently using?

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