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

Abstract

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

Abstract

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.



Next Meeting

Tue, May 09 2017 12:00 Central Daylight Time


SQL Server 2016 Always On Availability Groups Perf & Internals - Jimmy May

RSVP: https://attendee.gotowebinar.com/register/2642717260694161411

SQL Server 2016 Always On Availability Groups Perf & Internals - Jimmy May

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. 1. Revealing the fantastic perf enhancements in SQL Server 2016 AGs 2. Sharing SQL Server 2016 AGs Log Transport & Log Redo improvements & internals 3. Documenting the benefits SQL Server 2016 on all flash storage environments, including how to use perform to observe µsec disk latencies


Jimmy May is a SQL Server Solutions Architect for the Data Propulsion Labs at SanDisk. He is a Microsoft Certified Master (MCM). He's formerly a Principal Architect at Microsoft as well as Senior Program Manager for the SQL Server Customer Advisory Team (SQL CAT) where he managed the Customer Lab which hosts the biggest, fastest, & most interesting SQL Server apps from all over the world. He is a founder of the IndyPASS & IWUG user groups.

Back to Top