September 20, 2001 at 9:59 am
Hi.
I'm DBA where exists 30 servers running SQL Server.
I need implement one process or job for monitoring and alert where these servers down.
I answer....Why ?????
Thanks
Eduardo
Sao Paulo - Brasil
September 20, 2001 at 3:12 pm
You can setup one server as the main alert server and send alerts to that one server.
Alternatively, there are any number of packages from NetIQ, CA, WhatsUp, etc that will montior your servers.
Steve Jones
September 20, 2001 at 7:09 pm
Hi
Im not 100% sure on this, but check perfmon out, from memory you can set an event to throw an email or netsend message when the instance is down. There is a variety of counters that you can monitor and send events about so well worth a look. Might not be an ideal solution for you.
Cheers
Chris
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
September 21, 2001 at 9:13 am
We don't have any of the commercial packages, so I ended up writing a DTS job that checks once an hour for servers in a given list. It tries to make a connection to the server using ADO (VBScript job step). I then check connection status. We have several categories for our servers, and certain people should be alerted based on category. What happens is after it checks each server, it sends one e-mail message (using xp_sendmail) to a person, alerting said person to which servers are down.
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley
September 21, 2001 at 9:54 am
I've used NetIQ and HP Openview to do this for us. Both will restart sql server if it dies and the box is still running. Other that that I would use bkelly's idea of the polling from a master server.
Wes
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply