SQL Server 2014 and 2012 AlwaysOn Availability Groups
SQL Server’s coolest new feature gives you high availability, disaster recovery, scale-out reads, and much more. Here’s our posts and tutorials on how to use it.
Introduction to AlwaysOn Availability Groups – Brent explains why this new feature in SQL Server is better than any high availability or disaster recovery feature we’ve had before and how it can help your business.
How to Setup AlwaysOn Availability Groups
Free AlwaysOn Setup Checklist PDF – Get started with our big setup checklist that covers planning, Windows, SQL Server, and the Availability Group setup.
An Introduction to SQL Server Clusters – AlwaysOn relies on Windows clustering, but relax – this isn’t your grandfather’s clustering. Kendra Little explains the differences between shared disk clustering and the AlwaysOn Availability Groups clustering.
How to Set Up AlwaysOn Availability Groups – A screenshot tour showing a simple lab installation from start to finish.
Video – How to Test Availability Groups in SQL Server 2012 – Kendra Little shows you how to set up a lab using free virtualization software and evaluation versions of Windows and SQL Server to get started learning AlwaysOn.
Using AlwaysOn Availability Groups in Amazon EC2 – If you’d like to use the cloud as a disaster recovery datacenter or just get higher availability by spreading your SQL Servers between availability zones, Jeremiah Peschka explains how to do it.
Why Availability Groups Make It Cool Again to Be a Sysadmin – Sideburns and sysadmins are back with a vengeance. DBAs need a lot of help from sysadmins in order to get AlwaysOn functionality up and running.
Managing SQL Server Availability Groups
Where to Run DBCC – you can run this corruption test against any of your SQL Server instances now, not just the primary, but should you only run it on a secondary? Brent explains why it’s closely related to where you run backups.
Why Your Network Connection Matters – if your primary SQL Server’s network connection blips, even for a moment, your databases will go offline if they’re in an Availability Group. Brent explains how to work around it.
Auto-Scaling AlwaysOn AGs – if you run replicas under VMware or Hyper-V, in theory, you could automatically scale up and down your Availability Group.
Before You Fail Over a Replica – when it’s time to do a manual failover, know how much data you will lose, how to handle Agent jobs, and what you’ll do in a split-brain scenario.
Corruption, Backup Checksums, and AlwaysOn AGs – an error in Books Online that you need to understand when designing a backup and DBCC strategy.
Case Studies of Always On Availability Groups
After many real-world deployments in production, here’s a recap of some of the most important lessons we’ve learned, including why you shouldn’t run AlwaysOn Availability Groups atop Windows Server 2008:
AlwaysOn AGs at StackOverflow.com – the real-life story of how StackExchange used SQL Server 2008, what they needed from their AlwaysOn deployment, and how it worked out.
Want Help? We Specialize in AlwaysOn.
We’re a boutique consulting company that specializes in high performance and high availability for Microsoft SQL Server. Some of our high-profile AlwaysOn deployments include StackOverflow, Discovery Education, and AllRecipes.
Our SQL Critical Care® process identifies the root cause of your performance and downtime problems, puts it in writing, and trains your staff how to work together to get pain relief – all in just 3-4 days.