How to check latency for user database.

• sizal0234

  SSCrazy

  Points: 2272

  More actions

  April 12, 2021 at 7:15 pm

  Go to Answer

  #3870228

  Hi,

  One of the user databases was in Not synchronizing / In recovery mode. The root cause was the storage being full which was taken care of. Now, I am able to access the database and think it is catching up but how would one know what percentage of latency?  or time it will take for the user database to be fully in sync with the primary?. Is there anyway way to find this out from the AG Dashboard, or any script or DMV that gives this information? Please let me know your thoughts.

  AG mode = Asynchronous commit.

  SQL Server 2016.

  Thanks!

• e4d4

  SSCertifiable

  Points: 5777

  More actions

  April 12, 2021 at 7:25 pm

  Answer

  #3870229

  Hi

  you need to add column Estimated Recovery Time (seconds) to AG dashboard, it will show how long it will take secondary to catch up with primary.

  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