question

sakuraime avatar image
0 Votes"
sakuraime asked Cathyji-msft commented

Always-on dashboard information .

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-general
image.png (13.4 KiB)
· 1
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.

Hi @sakuraime,

Just checking in to see if the answer(s) helped.
If an answer is helpful, please "Accept answer" or "Up-Vote" for the same which might be beneficial to other community members reading this thread.

0 Votes 0 ·
TomZika avatar image
0 Votes"
TomZika answered

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://docs.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


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.

Cathyji-msft avatar image
0 Votes"
Cathyji-msft answered Cathyji-msft edited

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.

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.