September 27, 2016 at 11:41 pm
Long story short, i am in the middle of planning to migrate our databases from a variety of versions to SQL 2014 Always On.
A third party has come in and documented what the new infrastructure should look like.
In a nutshell, there are 2 hosts in one datacenter, 1 being the primary replica and the second for reporting, and then another one in the other datacenter for failover.
Happy days. We have High Availability.
Reading the proposal i have questions, and rather than look like a fool with the third party, i would rather look like a fool on here. 😛
Hopefully someone can answer the below:
1. My understanding of the licencing is that Microsoft supplies 1x additional replica for free. If my client wants to save money, then adding an extra replica for reporting isnt going to save him much. Good performance for reports. Correct me if i am wrong on this.
2. Secondly, they have specified that there will be 3 networks for the Always On setup.
One for the public address. Cool. Thats what the client connect to.
One for the heartbeat. Yep thats sweet.
Then another one for data synchronisation. Now this one i am baffled on. I cant work out how you would go about setting up a dedicated network for data synchronisation. Or even specifying SQL Server to use this network for data syncs.
So what would you normally setup your Always On Clusters with?
Heartbeat and public right?
September 28, 2016 at 2:47 am
1. My understanding of the licencing is that Microsoft supplies 1x additional replica for free. If my client wants to save money, then adding an extra replica for reporting isnt going to save him much. Good performance for reports. Correct me if i am wrong on this.
--Microsoft allows as many secondaries as you want as long as they are truly passive. No reporting, no backups = no license on passive nodes
--Microsoft allows as many secondaries as you want as long as they are truly passive. No reporting, no backups = no license on passive nodes
Dont worry about asking questions to third parties, I am sure you have paid them so I would get as much info as possible from them
September 28, 2016 at 3:51 am
That sounds ok so far, but have a look at Perry Whittle's Stairway to AlwaysOn for a bit more background. Step 8 might be of interest.
September 29, 2016 at 4:38 pm
Thanks very much for the advice.
Thanks for the link. Reading Perrys stairway now.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply