April 18, 2016 at 6:55 am
How statistic update will happen in primary and secondary replicas in always on ?
April 18, 2016 at 7:38 am
AlwaysOn AGs (and traditional mirroring also) use the transaction log to replicate. Any operation that writes to the log is mirrored. Since updating statistics writes to the log, it is mirrored as well and should replicate.
April 18, 2016 at 7:59 am
The primary is going to follow the settings for statistics updates. It won't change because the database is in an Availability Group.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply