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!