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/
Niko Neugebauer
shared this idea
4 comments
-
Anonymous
commented
Want to know what you think about resetting my keyboard . What website do I need to go to reboot my. keyboard .
-
Anonymous
commented
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
Hi Matteo,
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.
Best regards,
Niko