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
This issue also exist even when on SQL Server 2017 CU31