question

sakuraime avatar image
0 Votes"
sakuraime asked sakuraime commented

Always-on Dashboard: last_commited_time

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.

sql-server-general
· 5
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.

Show some data please and explain that

0 Votes 0 ·

anyone has idea ?

0 Votes 0 ·

@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.

0 Votes 0 ·

oh. just missed you original reply , Or do you have example too. ?

0 Votes 0 ·
Show more comments

1 Answer

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

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).

28704-screenshot-2020-09-28-171955.jpg

28480-screenshot-2020-09-28-172153.jpg

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.



· 2
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.

thanks for your test.

Just wondering the commit time always same as the async replica when it's syncing

0 Votes 0 ·

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

0 Votes 0 ·