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
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
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 <ip of SQL server> -s0 -X
tcpdump -i 0.0 -nn host <ip of SQL server> -s0 -X
i am sending a string to look into status of sql table by using the following string
select [status] from mydatabase.dbo._ABC_IsAlive
like i say, i doubt that will work with curl.
but if you want to check run the tcpdump.