Microsoft Server 2008 R2 monitor

Hi eblair84

You have a couple of options. 1) You can do an LTM external monitor...this is a monitor that runs on the LTM but is an external monitor that will let you connect to the SQL instance, run a test, and consume the result. However, I am generally loathe to use "external monitors" on the LTM because if you don't do them smart, they can impact the LTM performance

Another option is to setup an HTML page on the SQL server that reports on the status of SQL on the SQL server. So you could add the role of IIS servers, then add a small script via a windows scheduled task that would run every X amount of minutes and check the status of SQL then output to a plain text HTML page that is served by IIS. Then you only have to use a standard ECV monitor on the LTM to consume that HTML page on the SQL server via IIS. That would be my advice versus an external LTM monitor

Let me know if you need more help setting up a simple status page on the SQL server for the LTM to consume for monitoring/VS checks

Thanks Matt