AlwaysOn – Knee Deep In Data

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)
- https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/overview-of-always-on-availability-groups-sql-server
Microsoft’s AlwaysOn Professional – Home of the MS SQL Server AlwaysOn Support Team
- https://blogs.msdn.microsoft.com/alwaysonpro/
Microsoft’s SQL Server AlwaysOn Team Blog
- https://blogs.msdn.microsoft.com/sqlalwayson/
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…
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”?
      - www.sqlservercentral.com/articles/Failover+Clustered+Instance+(FCI)/107536/
    - Stairway to AlwaysOn Level 2: Storage 101
      - www.sqlservercentral.com/articles/always+on/107537/
    - Stairway to AlwaysOn Level 3:Infrastructure 101
      - www.sqlservercentral.com/articles/cluster/107538/
    - Stairway to AlwaysOn Level 4: Analyse and Deploy a Windows Server Failover Cluster
      - www.sqlservercentral.com/articles/cluster/107539/
    - Stairway to AlwaysOn Level 5: Analyse and Deploy a Failover Cluster Instance
      - www.sqlservercentral.com/articles/cluster/107540/
    - Stairway to AlwaysOn Level 6:Analyse & Deploy an AlwaysOn Availability Group
      - www.sqlservercentral.com/articles/stairway/107542/
    - Stairway to AlwaysOn Level 7:Combining FCIs with Availability Gruops
      - www.sqlservercentral.com/articles/High+Availability+(HA)/109978/
    - Stairway to AlwaysOn Level 8: Segregate Mirror Traffic in AlwaysOn
      - http://www.sqlservercentral.com/articles/always+on/131901/
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.
Kendra Little Articles:
- 3 Ways Availability Groups Beat Database Mirroring
  - https://littlekendra.com/2015/12/17/3-ways-availability-groups-beat-database-mirroring/
- Why is My Transaction Log Growing in My Availability Group? (Dear SQL DBA Episode 36)
  - https://littlekendra.com/2017/03/30/why-is-my-transaction-log-growing-in-my-availability-group-dear-sql-dba-episode-36/
FPweb.net – “Understanding AlwaysOn & Mirroring with SQL Server 2012”
- https://www.fpweb.net/sharepoint-blog/understanding-alwayson-mirroring-with-sql-server-2012/#.V4kQpaLseI5
Manvendra Singh’s “Add a SQL Server Database to an Existing Always On Availability Group”
- https://www.mssqltips.com/sqlservertip/5283/add-a-sql-server-database-to-an-existing-always-on-availability-group/
Amit Banerjee’s “Chasing the Ghost Cleanup in an Availability Group”
- https://troubleshootingsql.com/2014/07/25/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…
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…

AlwaysOn Articles from SQL Monitoring Tools:

Redgate’s SQL Monitor:
- General SQL Monitor Page:
  - https://www.red-gate.com/products/dba/sql-monitor/resources/articles/sql-server-availability-group-monitoring
- SQL Backup Pro 8.0 Documentation
  - https://documentation.red-gate.com/display/SBU8/AlwaysOn+Availability+Groups
- Monitoring SQL Server Failover Cluster Instances and AlwaysOn Availability Groups hosted in Azure IAAS
  - https://documentation.red-gate.com/sm7/configuring-sql-monitor/adding-and-configuring-servers/adding-servers-to-monitor/monitoring-sql-server-failover-cluster-instances-and-alwayson-availability-groups-hosted-in-azure-iaas
SentryOne and Performance Advisor:
- General SentryOne Page:
  - https://www.sentryone.com/sql-server/alwayson
- Always On Availability Groups & VMs by John Martin
  - https://blogs.sentryone.com/johnmartin/availability-groups-vms/
- 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…
Solarwinds’ Database Performance Analyzer
- How to Register and Monitor an Availability Group
  - https://support.solarwinds.com/Success_Center/Database_Performance_Analyzer_(DPA)/Register_and_monitor_an_Availability_Group
- Interactive Demo:
  - http://database.demo.solarwinds.com/iwc/login.iwc

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:

24Hours of PASS
- SQL Server AlwaysOn Quickstart by Ryan Adams
  - Direct YouTube Link:

24Hours of PASS
- AlwaysOn in Microsoft SQL Server 2014 by Luis Vargas
  - Direct YouTube Link:

Virtual Group Webinars
- SQL Server 2016: Always On Enhancements by Percy Reyes
  - Direct YouTube Link:

Virtual Group Webinars
- Migration to SQL Server AlwaysOn lessons learned
  - Direct YouTube Link:

Virtual Group Webinars
- AlwaysOn Multi-Site configurations by John Martin
  - Direct YouTube Link:

Virtual Group Webinars
- Install an AlwaysOn Failover Cluster and Availability Group by Ryan Adams
  - Direct YouTube Link:

Virtual Group Webinars
- Troubleshooting AlwaysOn Availiablity Groups in SQL 2014
  - Direct YouTube Link:

Virtual Group Webinars
- Is AlwaysOn the Right high Availability and Disaster Recovery Plan for me? by Ryan Adams
  - Direct YouTube Link:

Pragmatic Works
- What’s New in AlwaysOn Availability Groups in SQL Server 2016
  - Direct YouTube Link:

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…)

Brent Ozar
- AlwaysOn Availability Groups Quiz and FAQ
  - Supporting Q/A Link:
    - https://www.brentozar.com/archive/2015/02/alwayson-availability-groups-faq/
  - Direct YoutTube Link:

SentryOne
- AlwaysOn Monitoring with Performance Advisor
  - Direct YouTube Link:

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…