Share via

AlwaysOn Sync Setup

Vishal Garg 1,576 Reputation points
2021-07-22T13:42:24.357+00:00

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 | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

0 comments No comments

1 answer

Sort by: Most helpful
  1. Cris Zhan-MSFT 6,676 Reputation points
    2021-07-23T02:49:59.587+00:00

    Hi,

    It seems that you have asked this question.
    https://learn.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.

    Was this answer helpful?

    0 comments No comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.