Hi,
In which situations we need to have Replication on Always on Availability groups? Always on availability allows read connections on secondary server then why do we need to configure additionally replication?
Thanks,
Ramana
asked
Replication with Always on Availability
That will depend on requirements.
Maybe you don’t have the money to license an identical replica so you cannot do read only secondaries.
Maybe you don’t have the money to license Enterprise edition so again you cannot do read only secondaries.
Maybe you need to replicate data to a secondary system for latency reasons.
Main OLTP in London, but you have point of presence in Hong Kong, Sidney, Seattle, New York etc, you replicate your the local data centres to stop large latency in all sites accessing London.
Maybe you just don’t want people to use readable secondaries due to potential redo performance problems so you want to keep people out as HA/DR is more important on that system than reporting.
You have centralised reporting data warehouse etc so again you need to replicate data to a DW.
There are many reasons I can think of.
16 People are following this question.
