The A to Z of Availability Groups
Ever since it was introduced in SQL Server 2012, availability groups (AGs) have been a source of interest, curiosity, and confusion. We’ve hit a point where many are seriously evaluating and looking to use AGs, but they are deceptively easy to deploy. While AGs share some common traits with both database mirroring and clustered instances of SQL Server (FCIs), the feature is its own entity. This full day pre-conference session will focus on getting you up to speed with AGs in SQL Server 2012 and 2014. Some of the major topics include:
- The real difference between FCIs and AGs – one of the sources of confusion since they both use an underlying Windows Server failover cluster (WSFC)
- Planning a WSFC for an AG deployment, including things like networking and hybrid scenarios that involve the cloud
- WSFC quorum for AGs
- Failure scenarios and how to recover from them
- Tips, tricks, and best practices for deploying AGs and their administration
If possible (dependent upon venue and cost), an AG lab may be possible during the day. Details will follow.
Sorry, there are no downloads available for this session.
Cluster MVP Allan Hirt is a consultant, published author, speaker, and trainer who has used SQL Server since 1992. Allan travels all over the world to work with and train clients and is currently finishing his latest book, Mission Critical SQL Server due in 2014.
The video is not available to view online.