The official SQL Server AlwaysOn team blog.
AlwaysOn Availability Groups Troubleshooting and Monitoring Guide provides information on troubleshooting the common AlwaysOn Availability Groups issues and monitoring the availability group health. We will try to keep updating this guide as new troubleshooting scenarios are documented so that you can conveniently find all the information in one place.
Please send us feedback on it!
We recently did 17 million updates to a table and our asynchronous AG node fell more than 24 hours behind. This secondary node has identical hardware and drives. We rarely see any latency over one second. But, we rarely do these kinds of large updates at one time. Are there any settings or hardware improvements we can do so our secondary doesn't fall so far behind? I believe this is an I/O issue, not a network bottleneck. We are considering adding SSD caching, but I'm not sure this will help this issue.