lundi 20 août 2012 13:15
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.
Toutes les réponses
lundi 20 août 2012 13:31
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
- Marqué comme réponse amber zhangModerator lundi 27 août 2012 03:02
mardi 21 août 2012 21:41
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!