Forum Discussion
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