SteveMP
Aug 04, 2017Nimbostratus
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!