We have Server connected to Primary, Secondary DB instance. If any of these DB instance is shutdown, forced to shutdown, network disconnected etc, then server will failover to the secondary db and viceversa.
We want to test the 'DB Connection Pooling' feature involved in the DBFO mechanism.
Also, what measurements can we consider? like Connections Established, Connections Recovered, File descriptor count, etc.
The objective is we want to find the issues like whether the connections established, connection dropped, memory usage is ok, connections not leaking etc.
Please help in coming up with an efficient test approach.