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