SQL Server: AlwaysOn Availability Groups and Failover Cluster Instances - Monitor, and Troubleshoot.

This course will provide you the knowledge of troubleshooting problems and exploring the tools available to monitor, troubleshoot and identify the cause of common SQL Server AlwaysOn Availability Groups (AG) and Failover Cluster Instances (FCI) issues. Most of the content can be applied across all supported versions of SQL Server AlwaysOn AG and FCI. This workshop is targeted at SQL Server Architects, Database Administrators, IT professionals, and SQL Server support staff who wish to formulate a practiced approach to SQL Server AlwaysOn Availability Groups and Failover Clustering monitoring and troubleshooting.

Objectives
After completing this training, students will be able to:

• See common tools available for monitoring and troubleshooting
• Understand why availability group, cluster group fails over and why failover takes long time
• Understand availability Group Databases status like Recovery Pending and Not Synchronizing
• Learn how to troubleshoot the problems

Module 1: Common Tools for Monitoring and Troubleshooting

• Common Tools

Module 2: Failover Issues

• Why did my Availability Group failover?
• Why didn’t my Availability Group failover?
• Why did my FCI failover?
• Why did my FCI take a long time to failover?
• Why didn’t my FCI failover?

Module 3: Availability Group Databases Not Accessible

• Availability Group Database in Recovery Pending / Not Synchronizing State

Module 4: Setup and Configuration

• Failed to join database…to the Availability Group
• Cannot create Availability Group Listener
• Why is Read-Only routing not working?

Module 5: Connectivity

• Cannot connect to Availability Group Listener

Module 6: Performance

• Troubleshoot: Availability Group Exceeded RTO or RPO
• Troubleshoot: Slow Insert Update and Delete in Availability Group database and HADR_SYNC_COMMIT Waits