Forum Discussion

SteveMP's avatar
SteveMP
Icon for Nimbostratus rankNimbostratus
Aug 04, 2017

Best way to monitor SQL database driven websites?

We have several IIS and Sharepoint websites that are SQL driven websites. Lately, we have had issues where there is some SQL connectivity or slowness between the web servers and SQL. Connectivity through the LTM to the web servers is fine. The default GET monitor and even a receive string looking for content on a static page doesn't help. In fact it sometimes makes it worse by directing traffic to the web server with the "least connections", since that is the server that can't connect to SQL. Is there a monitor or monitors that can specifically verify the connectivity between the web servers and the SQL/Db servers driving the dynamic content?

 

Thanks!

 

1 Reply

  • Hamish's avatar
    Hamish
    Icon for Cirrocumulus rankCirrocumulus

    The HTTP monitor is configurable for specific URI's and return strings.

     

    Have the http monitor request a DYNAMIC page and check the content of that. You can configure whichever URI you want for the request, so just configure one that does hit the database. Then configure the Receive and Receive Disable strings to the appropriate values for the expected page being returned.