Server down alerting

Question

Recently I had a breakdown on one of my database instances.

Is it possible to get a notice on events, like when one of your DB instances doesn't start correctly, or don't respons?? I've like to had it on our NMS system via SNMP, but I could understand after some research that the feature hasn't been supported since 2005.

Its MSSQL08 by the way.

Answer 1

There's are loads of products available. It is imporatnt , when you're setting this up - to include some monitoring also on other components , such as disk . For example , a drive may not be available - but the SQL Server instance will still be available .

Analyse the possible points of failure (keep it to the critical path.

Architectuarlly , you also need to monitor the monitor. If the monitor is down - then some notification should be sent

---

Jack Vamvas sqlserver-dba.com

Answer 2

3 possible solutions :-

1) Use SQL Server jobs to send alert when SQL server Agent comes online

2) Use CMD task schduler to check SQL server service status in each 5 minues & send notification if SQL services are not runing

3) Use any third party tool to run time monitoring

---

Please click the Mark as Answer or Vote As Helpful if a post solves your problem or is helpful!