SQL Server 2012 - Multiple named Instances with Always On
Hi, Can anyone help me? I have two named SQL 2012 standalone Instances on each server. I would like to know what the best way to set up Always On . INST1(Principal) on SERVER1 --> Replica on INST2 INST2(Principal) on SERVER2 --> Replica on INST1 OR INST1(Principal) on SERVER1 --> Replica on INST2 INST2(Principal) on SERVER1 --> Replica on INST2 Thank you very much for your time and I really appreciate it!!! +Keny
If your severs see very much load, I would lean toward running the primary roles on separate servers. You might get some resource utilization benefit from splitting the primary roles out since CPU and I/O will tend to be more evenly balanced across the servers. If your servers are lightly utilized, then this isn't a critical decision. You can always set it up one way the, if you need to, change it later by synchronizing the replicas and failing over.