Logo Microsoft

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


Wichtige Information

Trainer: Antonio Turkovic

Dieser Kurs wird von einem internationalen Experten von Microsoft Premier Services gehalten und in Kooperation mit ETC angeboten. Für bestehende Microsoft Premier Kunden ist eine Direktbuchung über Ihr Technical Account Management möglich.

Inhalt des Trainings

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.

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


Jetzt online buchen

  • 19.03.-21.03.2024 19.03.2024 3 Tage 3T online Online
    Trainer: Antonio Turkovic
    Course language - German
    Remote Training

Preise exkl. MwSt.

Sie haben Fragen?

Ihr ETC Support

Kontaktieren Sie uns!

+43 1 533 1777-99