AlwaysOn Solution Guide: Offloading Read-Only Workloads to Secondary Replicas
In Microsoft SQL Server 2012, the AlwaysOn Availability Groups technology can address a common requirement of your existing high availability solution: utilization of secondary servers to result in high ROI of the investment in hardware. With AlwaysOn Availability Groups, these otherwise inactive secondary servers can be utilized as readable secondary replicas. This feature enables you to optimize your hardware utilization, thus achieving higher ROI for your hardware. Furthermore, it can help you to improve performance on the primary system by offloading your read-only workload to readable secondary replicas. This white paper describes how to configure AlwaysOn Availability Groups for offloading reporting workload to a secondary replica. It also describes the factors that can affect the high availability and the performance of your reporting workload.
Writer: Sunil Agarwal
Technical Reviewers: Kevin Farlee, Sanjay Mishra, Cephas Lin, Mike Weiner, Prem Mehra