Hi guys, can I know for mirroring, is it both principal and mirror server's hardware spec needed to be same in order to best performance during mirroring? I am just curious about it. Thx.
Best Regards,
Hans
NO, they don't have to be
Although you might want them to be, as the mirror server should be capable enough to be your primary server when needed
Plus, you can set them up identically, or try different settings to see how performance changes
It's likd RAID, you don't necessarily need same brand, same model, same size HDDs, but people always recommends it
|||Also, depending on the version of SQL2005, only the enterprise edition supports "high-performance" in asynchronous mode for mirroring. The standard edition only supports synchronous - so a gigabit or fibre channel is recommended. The speed between servers should also be considered for best mirroring performance, depending on your situation.
No comments:
Post a Comment