Always On AG- Readable Secondaries: How they work?

Readable Secondary AG databases internally use snapshot isolation under the covers. This will enable read-only workload to run against secondary databases.

http://www.sqldiablo.com/2012/08/01/alwayson-availability-groups-isolation-levels-selects-blocking-writers/

https://www.brentozar.com/archive/2014/01/careful-adding-indexes-with-alwayson-availability-groups/

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s