Here is a curated list of AlwaysOn related links that I recommend visiting:
AlwaysOn Articles:
- Microsoft’s “Overview of Always On Availability Groups (SQL Server)
- Microsoft’s AlwaysOn Professional – Home of the MS SQL Server AlwaysOn Support Team
- Microsoft’s SQL Server AlwaysOn Team Blog
- Brent Ozar – SQL Server AlwaysOn Availability Groups
- https://www.brentozar.com/sql/sql-server-alwayson-availability-groups/
- Note: this link contains a lot of supporting information like Checklists, .pdfs, videos, links to further reading, training courses, too much to list here…
- https://www.brentozar.com/sql/sql-server-alwayson-availability-groups/
- SQLServerCentral.com – Stairway to AlwaysOn by Perry Whittle
- Main Page:
- www.sqlservercentral.com/stairway/112556/
- Stairway to AlwaysOn Level 1: What is “SQL Server AlwaysOn”?
- Stairway to AlwaysOn Level 2: Storage 101
- Stairway to AlwaysOn Level 3:Infrastructure 101
- Stairway to AlwaysOn Level 4: Analyse and Deploy a Windows Server Failover Cluster
- Stairway to AlwaysOn Level 5: Analyse and Deploy a Failover Cluster Instance
- Stairway to AlwaysOn Level 6:Analyse & Deploy an AlwaysOn Availability Group
- Stairway to AlwaysOn Level 7:Combining FCIs with Availability Gruops
- Stairway to AlwaysOn Level 8: Segregate Mirror Traffic in AlwaysOn
- www.sqlservercentral.com/stairway/112556/
- Main Page:
- Brent Ozar – AlwaysOn Article Archives
- https://www.brentozar.com/archive/category/high-availability/alwayson-availability-groups/
- Note: this links contains a number of articles on the subject.
- https://www.brentozar.com/archive/category/high-availability/alwayson-availability-groups/
- Kendra Little Articles:
- 3 Ways Availability Groups Beat Database Mirroring
- Why is My Transaction Log Growing in My Availability Group? (Dear SQL DBA Episode 36)
- FPweb.net – “Understanding AlwaysOn & Mirroring with SQL Server 2012”
- Manvendra Singh’s “Add a SQL Server Database to an Existing Always On Availability Group”
- Amit Banerjee’s “Chasing the Ghost Cleanup in an Availability Group”
AlwaysOn Presentations:
- SentryOne – Monitoring and Performance Tuning for AlwaysOn by Kevin Kline
- Direct SQLbits.com Link:
- http://sqlbits.com/Sessions/Event11/Monitoring_and_Performance_Tuning_for_AlwaysOn
- Note: this is a direct video embedded in the SQLBits Site, I believe you can download the video and the slide deck…
- Direct SQLbits.com Link:
- Professional Association for SQL Server (requires free login)
- PASS Summit Recordings
- http://www.pass.org/Learning/Recordings/Listing.aspx?category=Summit
- SQL Server 2016 on Flash: Fast Track DW, SOFS, Columnstore, & AlwaysOn by Brian Walters
- AlwaysOn in SQL Server 2016 by Kevin Farlee
- Install an AlwaysOn Failover Cluster and Availability Group by Ryan Adams
- SQL Server AlwaysOn QuickStart by Ryan Adams
- Introduction to AlwaysOn Availability Groups by Adam Belebczuk
- SQL Server 2014 AlwaysOn (High Availability and Disaster Recovery) by Kevin Farlee
- Troubleshooting AlwaysOn Availability Groups in SQL 2014 by Trayce Jordan
- Into the Blue: Extending AlwaysOn Availability Groups by Joseph D’Antoni
- AlwaysOn in SQL Server 2014 by Luis Vargas
- CAT: AlwaysOn Customer Panel – Lessons Learned & Best Practices by Ayad Shammout, David Smith, Michael Steineke, Sanjay Mishra, and Thomas Grohser
- and many, many, more…
- http://www.pass.org/Learning/Recordings/Listing.aspx?category=Summit
- PASS Summit Recordings
AlwaysOn Articles from SQL Monitoring Tools:
- Redgate’s SQL Monitor:
- General SQL Monitor Page:
- SQL Backup Pro 8.0 Documentation
- Monitoring SQL Server Failover Cluster Instances and AlwaysOn Availability Groups hosted in Azure IAAS
- SentryOne and Performance Advisor:
- General SentryOne Page:
- Always On Availability Groups & VMs by John Martin
- Monitoring and Performance Tuning For AlwaysOn
- Direct SQLbits.com Link:
- http://sqlbits.com/Sessions/Event11/Monitoring_and_Performance_Tuning_for_AlwaysOn
- Note: this is a direct video embedded in the SQLBits Site, I believe you can download the video and the slide deck…
- Direct SQLbits.com Link:
- Solarwinds’ Database Performance Analyzer
- How to Register and Monitor an Availability Group
- Interactive Demo:
AlwaysOn Videos:
- PASS – High Availability Disaster Recovery Virtual Chapter – Microsoft SQL Tiger Team – Availability Group Troubleshooting Improvements
- Direct YouTube Link:
- Grant Fritchey’s Availability Group Monitoring in SQL Monitor
- Direct YouTube Link:
- PASS – High Availability Disaster Recovery Virtual Chapter’s “TroubleShooting AlwaysOn Availability Groups in SQL Server 2015” by Trace Jordan
- Direct YouTube Link:
- 24Hours of PASS
- SQL Server 2016 AlwaysOn Availability Groups Enhancements by Jimmy May
- Direct YouTube Link:
- SQL Server 2016 AlwaysOn Availability Groups Enhancements by Jimmy May
- 24Hours of PASS
- SQL Server AlwaysOn Quickstart by Ryan Adams
- Direct YouTube Link:
- SQL Server AlwaysOn Quickstart by Ryan Adams
- 24Hours of PASS
- AlwaysOn in Microsoft SQL Server 2014 by Luis Vargas
- Direct YouTube Link:
- AlwaysOn in Microsoft SQL Server 2014 by Luis Vargas
- Virtual Group Webinars
- SQL Server 2016: Always On Enhancements by Percy Reyes
- Direct YouTube Link:
- SQL Server 2016: Always On Enhancements by Percy Reyes
- Virtual Group Webinars
- Migration to SQL Server AlwaysOn lessons learned
- Direct YouTube Link:
- Migration to SQL Server AlwaysOn lessons learned
- Virtual Group Webinars
- AlwaysOn Multi-Site configurations by John Martin
- Direct YouTube Link:
- AlwaysOn Multi-Site configurations by John Martin
- Virtual Group Webinars
- Install an AlwaysOn Failover Cluster and Availability Group by Ryan Adams
- Direct YouTube Link:
- Install an AlwaysOn Failover Cluster and Availability Group by Ryan Adams
- Virtual Group Webinars
- Troubleshooting AlwaysOn Availiablity Groups in SQL 2014
- Direct YouTube Link:
- Troubleshooting AlwaysOn Availiablity Groups in SQL 2014
- Virtual Group Webinars
- Is AlwaysOn the Right high Availability and Disaster Recovery Plan for me? by Ryan Adams
- Direct YouTube Link:
- Is AlwaysOn the Right high Availability and Disaster Recovery Plan for me? by Ryan Adams
- Pragmatic Works
- What’s New in AlwaysOn Availability Groups in SQL Server 2016
- Direct YouTube Link:
- What’s New in AlwaysOn Availability Groups in SQL Server 2016
- Pragmatic Works
- How to video: AlwaysOn Availability Groups
- Direct YoutTube Link:
- https://youtu.be/a7SFS4TvRWM (Video would not embed into page, must navigate manually or search the above title in YouTube…)
- Direct YoutTube Link:
- How to video: AlwaysOn Availability Groups
- Brent Ozar
- AlwaysOn Availability Groups Quiz and FAQ
- Supporting Q/A Link:
- Direct YoutTube Link:
- AlwaysOn Availability Groups Quiz and FAQ
- SentryOne
- AlwaysOn Monitoring with Performance Advisor
- Direct YouTube Link:
- AlwaysOn Monitoring with Performance Advisor
- SentryOne
- Monitoring and Performance Tuning For AlwaysOn
- Direct SQLbits.com Link:
- http://sqlbits.com/Sessions/Event11/Monitoring_and_Performance_Tuning_for_AlwaysOn
- Note: this is a direct video embedded in the SQLBits Site, I believe you can download the video and the slide deck…
- Direct SQLbits.com Link:
- Monitoring and Performance Tuning For AlwaysOn