it seems i missed to scrolled below points in documents for multisubnetfailover=true, so added here ..my bad..Thanks Step 1: Once the application tries to connect to the database using a SQL listener, it connects with DNS and asks for the IP address of it Step 2: DNS gives all virtual IP address mapped with a SQL Listener. In this example, DNS returns two IP addresses Step 3: In MultiSubnetFailover= True, it tries to connect with all IP addresses returned by DNS in parallel. It does not wait for the timeout to occur from an IP address Step 4: Once a connection is established with one IP address, the application can connect to the database
it seems i missed to scrolled below points in documents for multisubnetfailover=true, so added here ..my bad..Thanks
Step 1: Once the application tries to connect to the database using a SQL listener, it connects with DNS and asks for the IP address of it
Step 2: DNS gives all virtual IP address mapped with a SQL Listener. In this example, DNS returns two IP addresses
Step 3: In MultiSubnetFailover= True, it tries to connect with all IP addresses returned by DNS in parallel. It does not wait for the timeout to occur from an IP address
Step 4: Once a connection is established with one IP address, the application can connect to the database
Wow perfect explanation sir tysm :)