Chapter 25AlwaysOn Availability Groups


  • Identifying all aspects of Availability Groups and mastering all their intricacies
  • Researching hardware and software configurations to identify what works best for your organization
  • Configuring hardware and then clustering the operating system
  • Configuring SQL Server 2014 Availability Groups
  • Administering and troubleshooting the production SQL Server 2014 Availability Group
  • Testing, monitoring, and tuning for performance

An Availability Group is a feature of AlwaysOn in SQL Server 2014 delivering robust, high-availability enhancements that greatly improve the data mirroring capabilities that shipped starting with SQL Server 2005. With AlwaysOn, SQL Server 2014 implements Availability Groups that deliver similar capabilities to database mirroring. In addition to these key enhancements, it can support up to nine replica partners, multiple databases in a single group, and readable replica secondary servers. The primary and replica servers can be mixed in asynchronous/synchronous modes and do not require shared disks. As a result, they can deploy across different geographical locations.

When these databases have dependencies, you can group them in a single Availability Group to failover together as a single failover unit. For example, by supporting readable replica servers, you can offload a reporting or read-only workload to a secondary replica, reducing the load on the primary replica and thus enabling it to scale ...

Get Professional Microsoft SQL Server 2014 Administration now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.