Readable Secondary Replicas

  • Uttam Parui
  • Vivek Sanil


Now that we have created an Availability Group and made sure it’s configured correctly, let’s take a look at how to fully leverage the features provided by this technology within SQL Server. The secondary replicas participating in the Availability Group maintain redundant copies of the production data on the primary replica. Wouldn’t it be nice to leverage the redundant copies and the processing power on the secondary replicas to offload some of the production workload? The readable secondary feature within Always On Availability Groups allows you to do that.


Redundant Copy Primary Database Snapshot Isolation Secondary Database Application Intent 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Copyright information

© Uttam Parui and Vivek Sanil 2016

Authors and Affiliations

  • Uttam Parui
    • 1
  • Vivek Sanil
    • 2
  1. 1.MooresvilleUSA
  2. 2.San AntonioUSA

Personalised recommendations