High Availability and Disaster Recovery

The High Availability & Disaster Recovery Virtual Chapter focuses on one of the most important aspects of a business - data availability. The goal of the HA&DR Virtual Chapter is to provide a PASS community for Microsoft SQL Server professionals to learn more about how to protect their data and minimize the risk to a business. Join us in our monthly webinar series to learn more about the numerous tools and techniques for SQL Server business continuity. Our webinars are held on the second Tuesday of each month at 1pm Eastern. Make sure to join this Virtual Chapter in the myPASS portal so you can stay informed of our learning opportunities.

Upcoming Meetings

April 2017 Monitoring your Always On environment
Tue 4/11/2017 1PM EST
Speaker: Sourabh Agarwal ( Microsoft SQL Tiger Team)

Webinar Link :https://attendee.gotowebinar.com/register/2989001850792031747


Monitoring a distributed environment is always challenging. Join this session to find out how the new enhancements available in SQL Server and existing solutions can help track your SLAs and respond in a timely manner. We will demystify common myths about how data flows from one replica to another and also explain how to monitor the data flow.

May 2017 SQL Server 2016 Always On Availability Groups Perf & Internals
Tue, May 9th, 2017 12:00 PM - 1:00 PM CST
Speaker: JImmy May (SanDisk)

Webinar Link : https://attendee.gotowebinar.com/register/2642717260694161411


Always On Availability Groups (AGs) were introduced in SQL Server 2012. AGs significantly expanded our HA/DR options. However, in both SQL 2012 and SQL 2014 two limitations were extant in the code—both Network Transport and Log Redo significantly compromised performance. In SQL Server 2016, these limitations have been significantly improved.


Our work shows enhancements of 7x – 10x, allowing over 1/2GB/s (4Gb/s) across the wire. These improvements expand solutions options for Tier 1 OLTP and Data Warehouse workloads, Tier 1 and Tier 2 consolidation, and more. This presentation explains the improvements, characterizes the new solutions, and shows commodity servers and modern non-shared in-server flash storage showing the profound contrast between SQL Server 2014 vs. 2016. Doing so moves the performance bottleneck from the SQL Server codebase to the CPU where it belongs.

Back to Top