Perth Microsoft Data and Analytics User Group

Event

Next Meeting: Thu, May 18 2017

AVAILABILITY GROUPS: WHAT THEY’RE NOT TELLING YOU

Language: English
Event Type: In-Person
Online Meeting URL: None
RSVPURL: https://www.eventbrite.com/e/pssug-availability-groups-what-theyre-not-telling-you-tickets-34403083549?ref=enivtefor001&invite=MTE5ODE5MTYvY29keUBjb2R5a29uaW9yLmNvbS8w&utm_source=eb_email&utm_medium=email&utm_campaign=inviteformalv2&ref=enivtefor001&utm_te

SQL Server 2012 brought to life a new form of high availability and disaster recovery in the form of Availability Groups (AGs). This all sounds fantastic, but in reality there are issues and problems that are generally not discussed, or well known, that can impact your HA/DR story and cause major performance issues. In this session, I’ll give a brief overview on AGs in SQL Server 2012 and the enhancements that come in 2014 and 2016. Then we’ll get into some of the problems that exist, that I’ve seen in the real world of using AGs, and that you should be aware of before implementing it in your environment.

(This is a tour de force of real-world technical issues with AGs seen in 5x9 architectures and this information isn't readily available anywhere else! Highly recommended if you're ever going to use AGs seriously! - CK)

 

When

iCal
UTC : Thu, May 18 2017 09:00 - 11:00
Event Time : Thu, May 18 2017 17:00 - 19:00 (UTC+08:00) Perth
Your Local Time: Thu, May 18 2017 09:00 - 11:00

Where

Level 3, 100 St George's Terrace
Perth , WA

Direction: None

Featured Presentation

AVAILABILITY GROUPS: WHAT THEY’RE NOT TELLING YOU

Speaker: Nicholas Cain

Summary: SQL Server 2012 brought to life a new form of high availability and disaster recovery in the form of Availability Groups (AGs). This all sounds fantastic, but in reality there are issues and problems that are generally not discussed, or well known, that can impact your HA/DR story and cause major performance issues. In this session, I’ll give a brief overview on AGs in SQL Server 2012 and the enhancements that come in 2014 and 2016. Then we’ll get into some of the problems that exist, that I’ve seen in the real world of using AGs, and that you should be aware of before implementing it in your environment.

About Nicholas: Nicholas Cain is a Microsoft Certified Master with over 12 years of enterprise database administration experience. He has worked with all versions of SQL Server since 7.0 in critical highly available production environments. He has not hired dozens of DBAs over the last few years.

Attachments

PASSChapterLogo100.jpg 

PASS provides the Perth SQL Server User Group with this website and other resources.

Microsoft provides us with a venue in which to host our meetings once a month.

OnCall DBA provides us with complimentary refreshments each month.

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids