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 ?