Always-on dashboard information .

sakuraime 2,316 Reputation points
2021-09-17T13:34:53.157+00:00

what's the usage of Synchronization performance(seconds) in the always-on dashboard ?
133162-image.png

does it means the time required between a the time db joined the Ag at the secondary replica and the time completely sync with the primary replica ?

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,690 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Tomáš Zíka 256 Reputation points
    2021-09-19T13:53:49.797+00:00

    According to the documentation:

    Synchronization Performance (seconds)
    Indicates the time in seconds it takes to synchronize between the primary and secondary replicas. This value is hidden by default.

    https://learn.microsoft.com/en-us/sql/database-engine/availability-groups/windows/use-the-always-on-dashboard-sql-server-management-studio?view=sql-server-ver15#group-by-availability-group-information

    0 comments
  2. CathyJi-MSFT 21,086 Reputation points Microsoft Vendor
    2021-09-20T06:23:52.733+00:00

    Hi @sakuraime ,

    This indicates the time in seconds it takes to synchronize between the primary and secondary replicas. Not only this situation that adding a SQL DB to AG. When the SQL AG has synchronization lag issue due to some network latency or some performance issue. We can use the column to evaluating data-synchronization time.

    If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar thread.

    0 comments