O'Reilly logo

Professional Microsoft SQL Server 2014 Administration by Brian Knight, Ross LoForte, Steven Wort, Bradley Ball, Adam Jorgensen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 25AlwaysOn Availability Groups

WHAT'S IN THIS CHAPTER?

  • 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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required