Design a AlwaysOn cluster

  • Hi!

    I got 5 SQL Servers 2008R2 (2x CPUs with 96-384Gb of RAM) with total 1500DBs and around 10Tb of allocated data. Now I´m forced to upgrade to 2012 and 2014, but the old hardware is overkill.

    Is it possible to consolidate this to a large SQL AlwaysOn cluster?

    We pros/cons could it be to have 2 or 4 nodes?

    2 or 4 sockets servers?

    My goal was to use ~20 cores Enterprise license on active server.

    Thanks for all input, Magnus

  • magnus.tengmo (5/8/2015)


    Hi!

    I got 5 SQL Servers 2008R2 (2x CPUs with 96-384Gb of RAM) with total 1500DBs and around 10Tb of allocated data. Now I´m forced to upgrade to 2012 and 2014, but the old hardware is overkill.

    Is it possible to consolidate this to a large SQL AlwaysOn cluster?

    We pros/cons could it be to have 2 or 4 nodes?

    2 or 4 sockets servers?

    My goal was to use ~20 cores Enterprise license on active server.

    Thanks for all input, Magnus

    A 4 node cluster with AlwaysOn groups is not what you' class as large.

    With a 2 node cluster you could have an Availability group that has 2 replicas only

    With a 4 node cluster you could have an Availability group that has 4 replicas only.

    It would pay to take a read through my stairway series on this site, starting at this link

    http://www.sqlservercentral.com/articles/FCI/107536/[/url]

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply