I need to write a VB.NET class that checks to see if SQL Server is running on the machine. This class will be mul-threaded and check every 30 seconds ( approx ) . The easiest way of doing this i suppose is to repeatedly attempt to open a connection and then close it. Or would it be better to open a single connection and then check the stage of the connection every 30 seconds ?
Is there a more eligent way of doing this.