We usually have some issues with one of our servers. We notice it was related to RAM and we are already dealing with it.
In the meantime, when the server becomes unresponsive, it will just lock all queries ( or just not respond ), and by that, it will not failover ( because server is frozen ).
What would be a good approach for a health check and, in case the server get's crazy, it will failover?
I was thinking about pinging via cmd and if it doesn't get a response after X times, it would failover but the server pings even when it's frozen.Also I tried a count for LCK sessions but, thats dangerous since during a normal day, it can reach for 1 or 2 seconds high ammounts of lcks.