[5-day-delivery] Troubleshoot SQL Server Availability Groups

Metadata

• Title: [5-day-delivery] Troubleshoot SQL Server Availability Groups
• Category: 5-day-delivery
• Tag(s): SQL Server, Troubleshoot, Always On, Availability Groups
• Description: You want to troubleshoot and fix Always On Availability Groups.

Common Issue(s)

• Always On Availability Groups Configuration (SQL Server)
• A Failed Add-File Operation (Always On Availability Groups)
• Timeout occurs when you connect to an Always On listener in multi-subnet environment
• Automatic failover problems in SQL Server Always On environments
• Availability group exceeded RTO
• Potential data loss with asynchronous-commit availability-group replicas
• Determine why changes from primary replica are not reflected on secondary replica for an Always On availability group
• High HADRSYNCCOMMIT wait type with Always On Availability Groups
• Error 9002. The transaction log for database is full due to AVAILABILITY_REPLICA error message in SQL Server

Management

• Fixed-time: 5 working day(s)
• Fixed-scope:
  • 1 availability group (1-5 database) OR
  • 1-5 basic availability group
• Fixed-price: $500

Work Breakdown

• Troubleshoot Always On Availability Groups Configuration (SQL Server)
• Troubleshoot a Failed Add-File Operation (Always On Availability Groups)
• Troubleshoot automatic failover problems in SQL Server Always On environments
• Troubleshoot Availability group exceeded RTO
• Troubleshoot Potential data loss with asynchronous-commit availability-group replicas
• Troubleshoot High HADRSYNCCOMMIT wait type with Always On Availability Groups

Out of Scope

• Some solutions might require planning for a maintenance window and thus are out-of-scope for this task.

Deliverable(s)

• The availability groups should synchronize.
• Recommendations
  • Database Level
  • Server Level
• Clarification call (up to 1 hour)

Prerequisite(s)

• Database server access
• Screen sharing, if applicable