January 16, 2025 at 2:40 pm
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
January 17, 2025 at 6:09 am
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
January 17, 2025 at 10:26 am
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" 😉
January 17, 2025 at 11:37 am
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 ?
January 17, 2025 at 12:08 pm
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" 😉
January 17, 2025 at 8:46 pm
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