Allow Updating Statistics on the Secondary Replicas of the Availability Groups
Allow remote (on the secondary replicas) statistics update for the Availability Groups. Given that a lot of time the secondary replicas have extra resources
Potentially this could lead into spreading & parallelising the statistics recalculation processes while doing maintenance or potentially even ad-hoc.
The original idea behind this is described in the following blogpost – http://www.nikoport.com/2019/06/20/updating-statistics-on-secondary-replicas-of-the-availability-groups/
Want to know what you think about resetting my keyboard . What website do I need to go to reboot my. keyboard .
How can I. how can I get results from the computer on how far reset my keyboard
Thanks for the clarification. We'll keep this open for future votes.
Niko Neugebauer commented
the point in this request is ALLOW updating the statistics on the secondary in the future.
My blog post was exactly on how to do this now (but rather on smaller tables).
I have previously spoken with the PMs responsible for the respective features (Sourab, Joe) and even Engineering Manager (Gjorgji) and all of them thought that it would be an interesting feature to consider.