Fixing Application Latency and Timeout issues in Multi-Subnet Always ON SQL Server Setup
Issue Application Team complained about latency in connecting to database through listener name. They also complained about application taking more time to connect to database after Always ON Group failover. Sometimes they observed application timeouts as well. Underlying database was part of Multi-Subnet Always ON SQL Server. Application was connecting to database using Listener IP. … Read more