SQL Server troubleshooting
Welcome to SQL Server troubleshooting. These articles explain how to determine, diagnose, and fix issues that you might encounter when you use SQL Server.
Diagnostic Tools to analyze logs
Download
High Availability and Disaster Recovery (Always On Availability Groups)
How-To Guide
- Troubleshoot issues with automatic failover Always On environments
- Determine the cause of Availability Group failover
- Use diagnostic tool AGDiag to diagnose Availability Group failures
- Troubleshoot latency on secondary replicas due to recovery (redo) queuing
- Troubleshoot latency on secondary replicas due to log send queuing
- Troubleshoot intermittent connection time-outs between availability group replicas
- Troubleshoot an AG database in reverting state
- Troubleshoot Always On availability databases in Recovery Pending or Suspect state in SQL Server
- Error with creating availability group due to permissions
- Troubleshoot most common Always On issues
Connection and Authentication
How-To Guide
- Network-related or instance-specific error
- Untrusted certificate authority error
- The certificate chain was issued by an authority that is not trusted
- Transfer logins and passwords
- Cannot generate SSPI context
- Timeout expired messages when connecting
- An existing connection was forcibly closed by the remote host