Deeply Understand connectivity to VNN listener and troubleshoot connection failures efficiently

Do you want to understand how connections are made to VNN listener in AG cluster? Maybe, you are facing some latencies or errors while connecting to listener. If so, this session is for you.
In this session, we create AG listeners in both single-subnet and multi-subnet AG clusters. Then, we will deeply investigate connections to these listeners by using Wireshark traces and also theoretically understand how connection is being established in the background. Finally, we will finish the session by troubleshooting one sample case where latency happens while connecting to AG listener.
In addition, you will be able to deeply understand how to set connection properties like MultiSubnetFailover, RegisterAllProvidersIP, HostRecordTTL.
Ket words: VNN listener, AG cluster, SQL Server, MultiSubnetFailover, RegisterAllProvidersIP, HostRecordTTL, single-subnet, multi-subnet
Chapters
0:47 - Agenda
1:00 - Connectivity to Single-Subnet AG cluster
1:01 - Create single-subnet AG cluster and listener
2:19 - Theoretical explanation of how connectivity is working in the background (Single-subnet case)
3:33 - Practical explanation of how connectivity is working in the background (Single-subnet case)
5:38 - Connectivity to Multi-Subnet AG cluster
5:39 - Create single-subnet AG cluster and listener
6:47 - Theoretical explanation of how connectivity is working in the background (Multi-subnet case)
9:15 - Practical explanation of how connectivity is working in the background (Multi-subnet case)
11:52 - Troubleshoot latency issue
📚 ►Full course on Troubleshooting sessions: • Troubleshooting
🧑‍💼►Follow me on LinkedIn - / bobirmirzo-arslanov-54...
Watch all my playlists here:
🚀►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