I have an issue on 2016 where Last_sent_time and Last_received_time columns in the DMV dm_hadr_database_replica_states does not get updated. Coincidently we are seeing issues related to timeouts when the times are finally updated which makes me think there is some kind of pressure happening or the redo logs are not being sent to the secondary correctly.

This seems to be related to CDC as one database on my instance has CDC enabled and does not update, the other one doesn't have CDC enabled and does update.

Looking through different KBs etc In the following CUs for 2017 and 2019, this issue is fixed

KB5005226 - Cumulative Update 26 for SQL Server 2017 KB5007182 - Cumulative Update 14 for SQL Server 2019

However checking through 2016 SP3 and Hotfix it's not, probably because it is no longer under Extended Support. I understand there has to be a cut off but I would still like to understand what the issue is these 2 fixes were sorting.

Is there any way I can find more information of what the root cause was for these fixes? I can't find anything online and the KBs above don't have links to any known KBs

2

There are 2 answers

2
pokiri On

This issue also exist even when on SQL Server 2017 CU31

0
Lee On

Opened a ticket with Microsoft who were unable to supply a hotfix for me or offer any information about what is contained within the fixes for 2017 and 2019. So unfortunately there is no resolution for this if you are on 2016, other than upgrade versions.