Should I execute Rebuild\\Update Statistics Job after failover in Always on

• anujkumar.mca

  SSChasing Mays

  Points: 621

  More actions

  September 18, 2019 at 8:10 am

  #3680996

  Folks,

  Please help me with below query.

  I have two instance Inst1 and Inst1 participating in Always-ON.

  Inst1 is primary from last 2 months. So rebuild indexes and update statistics are running on primary one.

  Today, I have to do the failover. Now Inst2 is primary now. (maintenance job was not running at inst2 earlier as it was secondary)

  My Query is, would failover cause performance issue as statistics didn't be updated at inst2 ?

• Sue_H

  SSC Guru

  Points: 90860

  More actions

  September 18, 2019 at 8:06 pm

  #3681213

  Statistics updated on the primary will be sent to the secondaries. There is a bug on 2016 with updating stats with fullscan so you would want to make sure you have the correct service pack, CU applied. Refer to:

  FIX: Bad query plan created on secondary replicas after FULLSCAN statistics update on primary replica in SQL Server 2016 SP1

  Sue