Microsoft Server 2008 R2 monitor

I'm not sure I made this question especially clear. Here's maybe a better run-down of the specifics: Database server: Microsoft SQL Server 2008 R2 with SQL database instance F5 Appliance: BigIP 11.5 HF5 physical device Monitor: barebones MSSQL monitor without send/receive but with username and password for connection. JDBC driver decompressed to /root/[user-created folder] The end result is that the monitor does not appear to be set up correctly in that the back-end resource is still listed as being down. I'm curious what the next step for the JDBC driver is, besides just being unzipped into a new folder. Thanks, Chris

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