Do you have a comment or suggestion to improve SQL Server? We’d love to hear it!

← SQL Server

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/

22 votes
Sign in
(thinking…)
Sign in with: Microsoft
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

Niko Neugebauer shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

2 comments

Attach a File
Sign in
(thinking…)
Sign in with: Microsoft
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close
Submitting...
  • Niko Neugebauer commented  ·   ·  Flag as inappropriate

    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

SQL Server: Suggestions

Feedback and Knowledge Base

(thinking…)
Hosted by UserVoice