Troubleshooting Common Scenarios with Always On - MS SQL Tiger Team

Two of the most common issues that Microsoft Support is contacted related to Always On Availability Groups are associated with Latency and Failovers. During this session, we will demonstrate walkthroughs for latency analysis and failover root cause using enhancements in SQL Server and Management Studio. After this session, you will be able to troubleshoot such issues easily, quickly and efficiently.

Amit Banerjee currently works as a Senior Program Manager for the Microsoft SQL Server Product Group. He has a decade of experience with SQL Server related environments. Prior to this role, he used to work as a Senior Premier Field Engineer at Microsoft specializing in proactive and advisory assistance for SQL Server environments. In the past, he has worked for the SQL Server Support team in various capacities including the Microsoft SQL Server Escalation Services team. He is the co-author for Pro SQL Server on Microsoft Azure and Professional SQL Server 2012: Internals and Troubleshooting.