Forum Discussion

Dede-DevCentral's avatar
Dede-DevCentral
Icon for Nimbostratus rankNimbostratus
Feb 17, 2017

Custom Health Check

Hi

 

I am hoping o get some help with a custom health check to SQL DB we have written the following strings Send String: select [status] from mydatabase.dbo._ABC_IsAlive Receive String: Alive username: f5healthcheck passord: sqldatabase

 

looking at my pool i can see it working because health monitors shows active

 

i will like to know the verbose curl command i can use to actually see that it is working because the server is sending back the correct string.

 

i want to know this because when we failover to our 2nd Data centre the pool does not go active the command will help me identify if the issue is server or else.

 

if you also know a health monitor debug and tcpdump command i can use that will be health

 

thank you for your time

 

D

 

1 Reply

  • i don't believe you can use curl (tool to send HTTP(S) requests to a webserver) to execute SQL queries. you will need something else there.

    what kind of health monitor are you using now?

    easier would be probably to do a

    tcpdump -i 0.0 -nn host  -s0 -X