Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have setup alerts to let me know when SQL Server shuts down normally. Now I want to add email alerts when it shutdown abnormally (system or process crash)

What is the easiest way to setup this secondary monitoring?

share|improve this question
up vote 1 down vote accepted

You can test connectivity periodically using SQLCMD from another server. If you have another server you can use SSIS to monitor a group of servers.

I've been playing with a program/webapp called splunk that can pull windows logs. You can set up a query that will get your offending entry and create an alert for when the count increases by one. It's free up to a certain threshold. It's a very cool tool.

share|improve this answer

A program like ActiveXperts can do service monitoring for you is you can't afford System Center Essentials. But it will only report the service as down, it does know the difference between a normal shutdown and a crash.

share|improve this answer

You might try orion from solar winds. We use this to monitor our systems. Works fairly well. You can monitor systems status, ac/dc status, some service statuses. You can change the polling time. It's fairly robust.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.