Share via

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.
14,168 questions
0 comments
Accepted answer
  1. CathyJi-MSFT 22,331 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
Most helpful Newest Oldest

Your answer

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