In this session, you will understand how synchronization works in SQL Server Availability group cluster and learn to troubleshoot synchronization latency issues.
Chapters
00:31- Availability Group Synchronization internals
03:56 - Performance monitor metrics to troubleshoot latency
11:15 - Extended event logs to troubleshoot latency
18:38 - AgLatency tool to troubleshoot latency
📚 ►Queries and commands used:
github.com/Bobirmirzo/AGSyncL...
📚 ►Full course on Troubleshooting CPU Spike in SQL Server: • Crash course on CPU ut...
🧑‍💼►Follow me on LinkedIn - / bobirmirzo-arslanov-54...
Watch all my playlists here:
🚀►Full course on Troubleshooting sessions: • Troubleshooting
🚀►Full course on Encrypting connections to SQL Server- • Full course on Encrypt...
🚀 ►SQL Server replication session: • SQL Server replication
🚀 ►SQL Server Always On Availability Group: • SQL Server Always On A...
🚀 ► SQL Server internals: • SQL Internals
🚀 ► Course in On-memory OLTP: • Course on In-Memory OLTP