define failover pool member

I would suggest you setup a cron job or scheduled task that collects the key metrics you want to make sure the SQL server is up and then have that script print out an HTML page to disk.

 

 

Serve that page over HTTP and point the ECV to that page.

 

 

That way your ECV doesnt muck with SQL on it's native port

 

 

We setup a system for mission critical nodes where there is a supervisor process that runs every minute and a few diagnostics that also run every minute. The diagnostics collect data and update a diag specific file in a directory that the supervisor then consumes and evaluates before overwriting the served html page.