Red Gate forums :: View topic - Failure to detect/notify server offline
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  | Register 
Go to product support center
SQL Monitor 3
SQL Monitor 3 forum

Failure to detect/notify server offline

 Search in SQL Monitor 3 forum
Post new topic   Reply to topic
Jump to:  
Author Message
mark_anderson_us



Joined: 28 Apr 2012
Posts: 19
PostPosted: Tue Jun 19, 2012 2:50 pm    Post subject: Failure to detect/notify server offline Reply with quote
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
Back to top
View user's profile Send private message
Chris Spencer



Joined: 29 Aug 2006
Posts: 300
Location: Red Gate - Cambridge
PostPosted: Tue Jun 19, 2012 5:12 pm    Post subject: Reply with quote
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
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
 You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group