question

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

AlwaysOn Sync Setup

In case there is a requirement to setup AlwaysOn on a SQL Instance , are there some performance parameters by which one can calculate the network bandwidth between 2 servers i.e I have a standalone server and I want to setup alwayson on it in Sync mode. Can I run some parameters on the SQL Instance before setting alwayson to calculate the network traffic which will be generated per second between the 2 servers , once alwayson is configured

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.

1 Answer

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

Hi,

It seems that you have asked this question.
https://docs.microsoft.com/en-us/answers/questions/419652/alwayson-sync-setup.html

Synchronization between Always on availability groups is by transferring transaction log records between primary and secondary replicas. Without configuring an availability group, how will it be monitored? Or you can monitor the transaction log write traffic for a period of time, then test the network bandwidth of the two servers, and then make an estimate.
But this may be different from directly sending log records to another server over the network.

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.