Post reply

Alert message when production server instance is down

  • May 17, 2010 at 9:12 am

    #143154

    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

    #1168366

    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 Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • May 17, 2010 at 11:37 am

    #1168378

    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.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply