Pre-SQLBits - Bristol SQL Server User Group - July Meeting

Monday 14 July saw the Bristol User Group meet with Brent Ozar talking on Are AlwaysOn Availability Groups Right for You? It was amazing that Brent came to share his in depth knowledge on AlwaysOn. He shared the pros and cons of what needs to be considered when creating this type of database architecture solution.

Brent has an amazing set of resources covering AlwaysOn. These are  found
http://www.brentozar.com/sql/sql-server-alwayson-availability-groups/ 

The Microsoft guides I found useful were:-

AlwaysOn Architecture Guide: Building a High Availability and Disaster Recovery Solution by Using AlwaysOn Availability Groups
http://msdn.microsoft.com/en-us/library/jj191711.aspx

Microsoft SQL Server AlwaysOn Solutions Guide for High Availability and Disaster Recovery
http://msdn.microsoft.com/en-us/library/ff929171.aspx

Comparison of Failover Cluster Instances and Availability Groups
The core concepts between FCIs and Availability Groups are compared in this table taken from http://msdn.microsoft.com/en-us/library/ff929171.aspx
 

For more details and caveats see the full article http://msdn.microsoft.com/en-us/library/ff929171.aspx