May 17, 2010 at 9:12 am
Hello folks,
I wanted to create an alert when one of my production server instance is down....How do i approach to this???.....
Thanks & Regards,
May 17, 2010 at 11:10 am
To know if servers are down, you need to enlist yet another server as the monitoring point, pinging the original servers to see if they're alive.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
May 17, 2010 at 11:37 am
If you are just looking for the instance, and not the server, you can have the service send a message when it's down. Otherwise you need another server running software, trying to connect or checking the service, and sending a note when it's down.
I've used software to do this in the past, What's Up Gold, Servers Alive, Unicenter, there are lots of choices.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply