Replication Statistics

  • In Transactional Replication, create index and Alter index commands do not get replicated to subscriber. Does UPDATE STATISTICS command get replicated to subscriber?

  • Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • This was removed by the editor as SPAM

  • No update statistics do not get replicated either.


    The only caveat to that would be when enough of the data has changed to kick off an AUTO UPDATE statistics background thread.


    replication is only concerned about insert/update/delete and any execute statements (if you replicate procedure calls) that change the actual data.

    it doesn’t replicate anything at the index or statistic level.

  • So, UPDATE STATISTICS command gets replicated in ALwaysOn, Mirroring and Log shipping?

  • Yes in those technologies all commands are synchronised as they take a full copy of the transaction log.


Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply