North Texas SQL Servers Users Group

Next Meeting




20 MAR 2014 NTSSUG Meeting

  • In-Person @ 7000 North Highway 161 Irving, Texas, United States (map)
  • 18:00 - 21:00 Central Daylight Time
  • Language: English

RSVP Here: None
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

Featured Presentation:

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:
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).

Supplementary Materials

The following event attachments are available to you:

Thank You to the 



of our May 2018 

SQL Saturday!

Back to Top