May I know on Always-on Dashboard: last_commited_time, is it always the same between primary , sync/async replica ?
given that sync replica is synced state
and async is syncing state.
May I know on Always-on Dashboard: last_commited_time, is it always the same between primary , sync/async replica ?
given that sync replica is synced state
and async is syncing state.
@Sakuramine Very bad, I asked you few information, can you read my comment, to add more information in your question to help but instead you ignored my response and posted this. It has always been told to you to post some details but i have seen you ignoring many times.
oh. just missed you original reply , Or do you have example too. ?
Hi @sakuraime,
May I know on Always-on Dashboard: last_commited_time, is it always the same between primary , sync/async replica ?
I test it in my environment. It is always same, unless the secondary replica has some issue(AG is not healthy).


Best regards,
Cathy
If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
thanks for your test.
Just wondering the commit time always same as the async replica when it's syncing
Hi @sakuraime,
Yes. If the AG state is heathy, the commit time always same.
If the response helped, please click "Mark as Answer" and upvote it.
Best regards,
Cathy
2 people are following this question.