SQL Server 2012 (“Denali”): AlwaysOn

AlwaysOn is a new integrated high availability (HA) and disaster recovery (DR) solution that provides redundancy within a datacenter and across datacenters to help enable fast application failover during planned and unplanned downtime.  Specifically, AlwaysOn delivers failover cluster instances, multiple secondaries, active secondaries, and connection director capabilities (multi-subnet and read-only intent).

AlwaysOn is the next evolution of database mirroring.  Database mirroring is relatively easy to set up, and it provides an almost instant failover when it’s used in High Safety mode.  However, database mirroring has several important limitations.  First, database mirroring is limited to a single failover partner.  In addition, database mirroring is capable of failing over only a single database at a time.  Database mirroring must be implemented either synchronously or asynchronously—you have to choose one or the other.  Finally, the databases on the mirroring server are in a state of recovery, so they can’t be directly accessed.  To use the data, you must take point-in-time snapshots of the databases.  AlwaysOn addresses all of these issues.

With AlwaysOn you can have up to four replicas (the new name for mirrored servers).  These replicas can be connected both synchronously (High Safety, for HA) and asynchronously (High Performance, for DR).  A new feature called Availability Groups lets you fail over multiple databases simultaneously.  The result is increased availability and uptime.

These replicas are not just passive secondaries, they are active and provide read-only access, so you can do things like take your reporting infrastructure off the primary and put it on one of the secondaries.  You can do a lot of sophisticated load balancing by distributing your overall workload across the various secondaries that you have.

Asynchronous secondaries will allow a company to set up either a regional or global high-availability environment, where the secondaries are spread across data centers.  This solution can provide a buffer for catastrophic site failures.  So, if one of your data centers were to experience an outage or an earthquake or something along those lines, it would immediately fail over to another data center, which could be in another state or even in another country.

AlwaysOn brings the technologies (mirroring, clustering, log shipping, and replication) together into a single solution.  And it’s easy: there’s a new management interface, which is wizard based, that basically walks you through the process of setting it up.  There’s also a dashboard that allows you to monitor the health and hygiene of the high-availability environment over time

More Info:

From Brent Ozar: SQL Server Denali AlwaysOn Rocks

TechEd Video: Microsoft SQL Server Code-Named “Denali” AlwaysOn Series,Part 1: Introducing the Next Generation High Availability Solution and Microsoft SQL Server Code-Named “Denali” AlwaysOn Series,Part 2: Building a Mission-Critical High Availability Solution Using AlwaysOn

SQL Server Denali – AlwaysON (HADR): Step-by-Setup setup guide

SQL Server AlwaysOn with Justin Erickson (video)

Online Help: AlwaysOn Availability Groups (SQL Server) and Availability Enhancements (Database Engine)

SQL Server Denali AlwaysOn–Q&A

AlwaysOn – New in SQL Server Code Name “Denali” CTP3

SQL Server 2012 – Always On

SQL Server Denali AlwaysOn vs. Database Mirroring

Microsoft SQL Server 2012: AlwaysOn Availability Groups Feature

SQL Server 2012 AlwaysOn: Multisite Failover Cluster Instance

SQL Server 2012 AlwaysOn High Availability and Disaster Recovery Design Patterns

Microsoft SQL Server AlwaysOn Solutions Guide for High Availability and Disaster Recovery

Using The AlwaysOn Feature of SQL Server 2012

SQL Server 2012 AlwaysOn Availability Groups – Part 1

AlwaysOn Architecture Guide: Building a High Availability and Disaster Recovery Solution by Using AlwaysOn Availability Groups

About James Serra

James currently works for Microsoft specializing in big data and data warehousing using the Analytics Platform System (APS), a Massively Parallel Processing (MPP) architecture. Previously he was an independent consultant working as a Data Warehouse/Business Intelligence/MDM architect and developer, specializing in the Microsoft BI stack. He is a SQL Server MVP with over 25 years of IT experience.
This entry was posted in SQL Server, SQL Server 2012, SQLServerPedia Syndication. Bookmark the permalink.

4 Responses to SQL Server 2012 (“Denali”): AlwaysOn

  1. Pingback: Learn SQL 2012 « Garrett Edmondson

  2. Rohit says:

    AlwaysOn seems to be a Microsoft marketing chore similar to Oracle’s Unbreakable.

    SQL Server had been lagging behind in most of the RDBMS features and I hope the 2012 edition fills the gap to some extent if not completely.

    I want to know if there is only a single server, how AlwaysOn works.

  3. Pingback: Fast Track for SQL Server 2012 | James Serra's Blog

  4. Pingback: SQL Server 2014: AlwaysOn - SQL Server - SQL Server - Toad World

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>