SQL Server Always On Series - Always On Availability group database not synchronizing

[@damodhardaamu9925]

Excellent explanation 😊

[@jbswiki]

Thanks !!!Glad you liked it.

[@amitshawant2155]

Hi @ JBSWiki 3 SQL VM are present in a cluster in same region. primary is in synchronus commit, one secondary replica is in synchronus commit and another secondary replica in asynchronus commit Issue is witht the commit time , sometime replica with async commit coudnlt able to meet the primary and sync commit replica in term of commit time what can be the issue.

[@jbswiki]

Hello Amit, All 3 servers are on same region, but 2nd secondary replica that is Asynchronous is on a different datacenter or all 3 servers on same datacenter?

[@amitshawant2155]

same region central india , all three @@jbswiki

[@surekhakharat3375]

I have one question dear my database is in sync with secondary server when we open alwayson dash board but insecondary server im alwayson database is not seen

[@jbswiki]

Could you check the Always on dashboard and see if it is all green?

[@amitshawant2155]

you can see always on dashboarf only from primary

[@jbswiki]

@@amitshawant2155, you can use the dashboard on Primary or secondary.

[@amitshawant2155]

@@jbswiki as I can check from primary I can see entire dashboard of primary as well as secondary however from secondary I am only able to see secondary dashboard. No primary is present on this.

[@jbswiki]

@@amitshawant2155 , that is normal. you can only see the details for Secondary replica from the Always on dashboard when checked on secondary.