AlwaysOn Standard o Enterprise edition

  • Hi everyone, I need advice from the experts,

    this is the structure I created for testing and it works wonderfully:

    AWS Balancer that serves 2 Windows server instances (on 2 different datacenters)

    -Server 1 EC2 c5.2xlarge with our application + SQL Server Evaluation.

    -Server 2 EC2 c5.2xlarge with our application + SQL Server

    Evaluation.

    the 2 servers will be accessible only with requests (Rest API) from mobile app

    Availability groups Always On synchronous mode with "read only on secondary replica"

    Number of databases 2:   database 1 about 5gb, database 2 about 8gb

    My question is this:

    With SQL Standard can I have only 2 replicas?

    With SQL Standard can I NOT have "read only" on the secondary?

    With SQL Standard can I use only 1 database?

    Which version of SQL Standard CAL or Core?

    With SQL Enterprise I can do everything ok but the costs seem very high?

    which SQL license should I buy?

    how many licenses do i need to buy 1 or 2 ?

    Standard - server $989 + 2 CALL 230$x2 ?

    Standard - per core $3945 ?

    Enterprise 2core package $15123 ? ;( ?

    thanks everyone for the help

    Alex

  • you may use Availability Groups (also known as AlwaysOn Availability Groups) on SQL Server 2022 Standard Edition, but with limitations - you can only create "Basic" Availability Groups which restrict the number of replicas you can add to a group, typically allowing only two replicas per group; to use more replicas, you need to upgrade to SQL Server Enterprise Edition.

    Basic Availability Groups:

    Standard Edition only supports creating "Basic" Availability Groups, which have restrictions compared to the "Advanced" Availability Groups available in Enterprise Edition.

    Replica limitations:

    With Basic Availability Groups, you can only add a limited number of replicas to a group, usually just two.

    Enabling Availability Groups:

    To use Availability Groups, you need to enable the "Always On Availability Groups" feature in SQL Server Configuration Manager.

     

    DBASupport

  • Basic AG supports only 2 replicas with 1 database, you can have a listener in basic AG.

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

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

  • Thanks for the reply,

    so I have to use SQL ENTERPRISE

    but the cost is this Enterprise 2core package $15123 ?

    and I have to buy 2, one for each server ?

  • depends on your current licence model, but yes you'll need a licenced edition for each replica.

    If you have enterprise agreement with software assurance you can get licence concessions for availability replicas, best to consult an MS licence partner

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

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

  • https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/SQLServer.ReadReplicas.html

    Not sure on the licensing - that is going to depend on how AWS charges for each instance.  I would definitely look into that and compare the costs.

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

Viewing 6 posts - 1 through 5 (of 5 total)

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