We have two
AlwaysOn availability replicas - secondary readable. We do have an incremental statistics on a large table. When a failover happens, SQL Server tries to update statistics on that table with
sample = 100%.
I've read that incremental statistics is not supported on AlwaysOn readable secondary databases.
So is it how SQL Server supposed to react on this situation?
We cannot allow this to happen, so our temporary solution is to remove those _WA_Sys_... statistics that SQL Server tries to update, then some of those statistics are still recreated by SQL Server but with a lot smaller sample rate.
Is anyone familiar with this issue and what can be done to prevent this kind of behavior?