question

Vishu-2318 avatar image
0 Votes"
Vishu-2318 asked Criszhan-msft edited

AlwaysOn Sync setup

Experts :

As of now we have one server on which one SQL Instance is there which needs to be converted to alwayson sync replication between 2 Alwayson instances in a DC(By following the required steps).

On the existing SQL Instance Is there a way to calculate the change of data(Databasewise in MB/GB) for judging the amount of data flow which will happen between the always on setup which will be coming up.

sql-server-general
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Vishu-2318 avatar image
0 Votes"
Vishu-2318 answered

This is SQL 2017/2019

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Criszhan-msft avatar image
0 Votes"
Criszhan-msft answered Criszhan-msft edited

Hi,

The Always on availability group transfers the transaction log records that occurred in the primary replica to the secondary replica, and then the secondary replica harden and redo these transactions.

With the secondary replica configured in synchronous commit mode, the primary replica needs to confirm that the secondary replica has completed log harden before it can commit the transaction (this may have some performance impact). When you want to evaluate the data size, rate and other factors synchronized by the Always on Availability Group, I suggest that you first configure an asynchronous commit replica, it will almost not affect the performance of the primary replica. After the configuration is completed, use the AlwaysOn performance counter(SQL Server, Availability Replica, SQL Server, Database Replica), or AlwaysOn related DMVs and dashborad to monitor these factors, and whether there are any delays, queues, etc. After that, you can change this replica to synchronous commit mode, or add another synchronous commit replica.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.