( 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

asked 17 May, 04:43

ekohariono's gravatar image

ekohariono
41114
accept rate: 0%

reverted 18 Jul, 03:29

Breck%20Carter's gravatar image

Breck Carter
26.9k440613886


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

permanent link

answered 18 Jul, 13:44

Mark%20Culp's gravatar image

Mark Culp
23.4k9132275
accept rate: 40%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×29
×3

question asked: 17 May, 04:43

question was seen: 82 times

last updated: 18 Jul, 13:44