Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

James Serra's Blog

James is currently a Senior Business Intelligence Architect/Developer and has over 20 years of IT experience. James started his career as a software developer, then became a DBA 12 years ago, and for the last five years he has been working extensively with Business Intelligence using the SQL Server BI stack (SSAS, SSRS, and SSIS). James has been at times a permanent employee, consultant, contractor, and owner of his own business. All these experiences along with continuous learning has helped James to develop many successful data warehouse and BI projects. James has earned the MCITP Business Developer 2008, MCITP Database Administrator 2008, and MCITP Database Developer 2008, and has a Bachelor of Science degree in Computer Engineering. His blog is at .

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


Leave a comment on the original post [, opens in a new window]

Loading comments...