Understand and troubleshoot latency in AG synchronization in SQL Server
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:
https://github.com/Bobirmirzo/AGSyncL...
📚 ►Full course on Troubleshooting CPU Spike in SQL Server: • Crash course on CPU utilization in SQL Ser...
🧑💼►Follow me on LinkedIn - / bobirmirzo-arslanov-548960173
Watch all my playlists here:
🚀►Full course on Troubleshooting sessions: • Troubleshooting
🚀►Full course on Encrypting connections to SQL Server- • Full course on Encrypting connections to S...
🚀 ►SQL Server replication session: • SQL Server replication
🚀 ►SQL Server Always On Availability Group: • SQL Server Always On Availability Groups (AG)
🚀 ► SQL Server internals: • SQL Internals
🚀 ► Course in On-memory OLTP: • Course on In-Memory OLTP