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 -
On SQL Server 2022 Std edition you can have multiple Basic Availability Groups.Each Availability Group can have only 2 replicas (primary and secondary)
- Jeffrey Williams wrote:
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.
It must be an infrastructure type machine not a ready built serving as its running eval edition which i'm sure aws don't supply
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs"
-
As noted, to go beyond this Enterprise is needed, which is $$$. There are a few features (including RAM/CPU limits that are higher in EE, but they coset.
Eval isn't allowed for production workloads, so if you use this you are in violation of the EULA.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply