Next Meeting: Thu, Mar 20 2014
20 MAR 2014 NTSSUG Meeting
6:00 - 6:20 - Welcome, Announcements & Food
6:20 - 8:30 - Troubleshooting Microsoft SQL Server AlwaysOn Availability Groups by Trayce Jordan
8:30 - 8:45 - Raffle and closing
Event Time : Thu, Mar 20 2014 18:00 - 21:00 (GMT-06:00) Central Time (US & Canada)
Your Local Time: Thu, Mar 20 2014 23:00 - 02:00
Microsoft Building LC-1
7000 North Highway 161
Troubleshooting Microsoft SQL Server AlwaysOn Availability Groups
Trayce Jordan Microsoft
Beginning with SQL Server 2012, the use of AlwaysOn Availability Groups is quickly becoming one of the primary HA/DR strategies in many organizations. Now that deployments of AlwaysOn solutions are increasing, knowing how to troubleshoot common problems is becoming equally important. This talk will focus on troubleshooting AlwaysOn Availability Groups. We’ll cover AlwaysOn health extended events, reviewing cluster logs, and SQL Error logs. In addition, we’ll cover the top issues we see at Microsoft from customers and how to resolve them: Unexplained failovers, databases not synchronizing, unable to create listeners, Read-Only routing not working, failure to join a secondary replica, endpoint permissions and more. We’ll also go through a list of perfmon counters and DMVs that are helpful in troubleshooting issues with AlwaysOn. We’ll have some slides for talking points and reference purposes, but most of it will be looking at actual logs and demonstrations – how a problems looks, how to diagnose it, and how to resolve it. Scripts will be made available.
About Trayce: Trayce has been working with SQL Server for almost 20 years (since version 4.21 and 6.0 days). He is one of the first certified masters, holding an MCM for SQL 2005 and has been working at Microsoft since 2006. Prior to joining Microsoft, he worked for a major online travel company as well as financial institutions and has served as a consultant working with companies in many different industries. His specialties include database performance tuning, operations management and support, high availability and disaster recovery. Within Microsoft, Trayce has held several roles to include dedicated Premier Field Engineer for DOD and intelligence agencies, as well as his current role as Senior Support Escalation Engineer within GBS (aka CTS, aka CSS).