Abstract
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.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2016 Uttam Parui and Vivek Sanil
About this chapter
Cite this chapter
Parui, U., Sanil, V. (2016). Readable Secondary Replicas. In: Pro SQL Server Always On Availability Groups. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-2071-9_10
Download citation
DOI: https://doi.org/10.1007/978-1-4842-2071-9_10
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-2070-2
Online ISBN: 978-1-4842-2071-9
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books