I need help to determine or review MS SQL diagram for new build.
What I want to accomplish is HA and HP MS SQL cluster build.
That would contain:
1. load balancer for WEB\Application server that would be hosted on VM, Win 2012r2
2. Side A 2 nodes cluster (active, passive) Physical servers - Win 2012r2
3. Side B 1 warm server for DR. Physical servers - Win 2012r2
4. SUN data storage.
I am wondering is this diagram has any logic.
What can be change to improve availability, performance, DR, etc.
What hardware components do I need to accomplish this?