( this question was originally posted on May 4, 2017 as a reply to Primary server/database hang when network latency slow (async mode HA) ) Hi All, Sorry late reply, Database Prod "Hang" when network form DC to DRC having many packet loss. DB Prod not "Hang" when network truly disconnect. --- 10.224.19.67 ping statistics --- 60 packets transmitted, 25 received, 58% packet loss, time 59307ms rtt min/avg/max/mdev = 13.878/17.504/30.287/3.962 ms Need your help how to configure mirror async, so DB Prod not "hang" when network "packet loss" issue. thx |
|
If you are getting high packet loss - which apparently you are - then I would suggest that you first look at your network and resolve whatever problems exists. e.g. you may have failing hardware (switch or router) that needs to be replaced? Configuring an ASYNC mirror is done in the same way as a "normal" synchronous mirror except you specify either asynchronous or asyncfullpage as the database mirroring mode. You use the SET MIRRORING OPTION statement to set the synchronization option. Mary's answer to your other question may also be of some help. HTH |
