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.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!