Posted on 2002-03-14
I have a VB application that connects to a database. I would like to have this app display connectivity to that database/machine based on a tiered level -just like stoplights (red -- bad, yellow -- ok, green -- good). How to go about this is up in the air. Should I run a query and time the query, and find acceptable ranges? Should I ping the machine and base it on response times? I'm sure other people have done this before, and I'm wondering what they found to be the best practice.