RE: [WhatsUp Forum] SQL Server Service

[Dave May]

I use three methods for each SQL Server I monitor:   1) Is the network working?       simple ICMP ping   2) Will the server accept new connections?       Custom TCP/IP Service to TCP port 1433, Send to disconnect command "QUIT\r\n"   3) Can I login to server and retrieve data?       Custom TCP/IP Service that loads an ASP page on my webservers that uses ADO to connect to the server, select top 1 * from whatever (nolock), and reports WHATSUP_DB_OK upon a successful connection.  Check the knowledgebase to get all the details of setting this one up.   Works like a charm,   Dave.   -----Original Message----- From: Fabr�cio Nunes Monte [mailto:[EMAIL PROTECTED]] Sent: Friday, August 31, 2001 9:26 AM To: Whatsup Forum Subject: [WhatsUp Forum] SQL Server Service I�m trying to monitor SQL Server service. How do I do to monitor this service ? If somebody know, please help me.   Thanks,   Fabricio Nunes Monte Analista de Sistemas - HOC .comDominio Ltda. Fax + 55 11 3104 6956   [EMAIL PROTECTED] www.comdominio.com.br