Perry Whittle (10/22/2014)
SQLAssAS (10/22/2014)
This question is just a sanity checkThis details an FCI in the prod and an FCI in the DR with an Availability group between them, correct?
If this is the case remember that you won't be able to configure automatic failover between the replicas. Why on earth do you want to have a DR instance that's clustered? DR is meant to be a short term usage until your live site is back online, totally unnecessary IMHO.
Also by using FCIs you're just re introducing the storage single point of failure
Yes automatic failover to DR will always a manual step if we have 2 servers at PROD for resilience so this is not too much of an issue for us. But thanks for clarifying that. Single point of failure on the storage is something i did not think about though! I will look closer at our storage set up to see what reslience we have here.
Would need to know a lot more about your storage configuration, but why are you constantly pulling in shared or replicated storage to the design? AlwaysOn does not promote or indeed require replicated or shared storage. Also by using replicated storage you're just re introducing the storage single point of failure.
The data replication is done at the software level. All nodes\replicas require simple, local, fast disk storage, spend time and money on boosting your network connectivity.
If we use a cluster on Prod it will obviously give server resilience and the availability group to DR gives automatic DR soltution if implemented properly. Thats the only reason I wanted use a cluster. I take your point on the Cluster at PROD and Cluster at DR as being overkill. THis is just due to the nature of the service it will be running. We would like ot have PROD and DR like for Like.
Thanks alot for your feedback it has given me a few things to think about.