How to set the interval between asynchronous commit

hazly 41 Reputation points
2021-02-08T04:36:00.05+00:00

I'm new to Basics Availability Group. We just installed a SQL Server 2019 Standard Edition and would like to setup a DR by having another SQL Server as secondary replica.
Would like to know what is the default interval for an asynchronous commit to send to the secondary replica, and can we change the interval time?
Lets say if we choose the synchronous commit, is the system going to instantly send to the secondary replica, and can we change the interval time?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,892 questions
0 comments No comments
{count} votes

Accepted answer
  1. CathyJi-MSFT 21,096 Reputation points Microsoft Vendor
    2021-02-09T07:32:38.773+00:00

    Hi @hazly ,

    > Would like to know what is the default interval for an asynchronous commit to send to the secondary replica, and can we change the interval time?

    No, there is no the interval time for this.

    > Lets say if we choose the synchronous commit, is the system going to instantly send to the secondary replica, and can we change the interval time?

    No, you can’t.

    Below is the steps of SQL AG log sync. Log Scanner and log redo threads are running continuously when some transactions occurred in primary replica.

    65722-1566440.png


    If the response is helpful, please click "Accept Answer", thank you.


0 additional answers

Sort by: Most helpful