• Hi guys so i got more information for you to help me decide what to do. I sent the following questions and got the reply in red:

    If so then what is the needfor clustering? Why can’t you just use Availability Groups?

    In our proposal we have 4nodes, each running an instance of SQL server, participate in a single windowsserver failover cluster that span two data centers. Also, it’s important tonote that this is a non-shared solution, and the nodes don’t share any storagewith another node. Each node is running an instance of SQL server and has itsown copy of data. 

    Back to you question whatis the need for clustering?? How you can build SQL cluster without windowscluster? This is per SQL Architecture, in order to enable Always on or any SQLCluster you need windows cluster after that you need to install SQL Cluster(Active / Passive) then you can enable always on. This is an active activesolution and specific for geo-cluster.

     

    Why are you proposingenterprise edition since we can have 2 nodes of SQL Server cluster on 2016Standard edition?

    Enterprise edition isrequired for Always on, Always on feature is available only with Enterpriseedition.  You will have 4 nodes of SQL Server cluster (two in eachdatacenter (active / passive)) then we will enable the always on between thetwo SQL Cluster. With this you will achieve 99.99 % High availability betweenthe sites and across both data center.

     

    Why didn’t you proposeanything on the CLOUD?

    Hosting in the cloud allowsyou to right-size your equipment for your current workload, and upscale easilyas workload increases

    We can do the same oncloud, but you need a site to site VPN and you need a good bandwidth for datareplication, in other hand, you need to consider the XenMobile Citrix Databaseand the performance. If your company policies allow the use of Windows Azure weare ready to change the design. Hence, you need to take in consideration thestorage, network, VM and SQL licenses + Consumption. (Same one Azure you needSQL enterprise with Software Assurance)

    What do you guys think?
    I feel something is not completely true as on top of all this the clusters will be virtualized so is this a yes or a no in your books?

    KY