How to monitor if SQL server is functional without opening a connection

  • We hava written a tool to monitor most of our services, and now we want to apply it to the sql server service.  Is there anyway we can get the information in the Java code, without logging into SQL server?  Basically we want a "ping" to SQL server....

    Thanks!

     

  • You Can use VBS to find whether the SQL Server is function from system services.In java u can use API that will make your Solution

    Arshad

  • Currently we are detecting the health of the SQL server service using WMI.  Just wonder if there is anything else we can do, such as SNMP?  Has anyone used SNMP with SQL server 2000? 

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply