Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
add comment

3 Answers

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
add comment

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
add comment

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
add comment

Your Answer

 
discard

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.