emeadaxsupport: Dynamics AX 2012 / R2 Retail: Switch from online to offline database is slow

[Blog bot]

Источник: http://blogs.msdn.com/b/axsupport/ar...base-slow.aspx
==============

Description:

In any environment you might have Network drops or have to do maintainance in your system. If you have configured the Retail Offline Database, you will be able to switch to this database if the connection is lost to the Store Database.

This process happens automatically, but we had Customer reporting that the time it takes to switch is too long. We have therefore created a hotfix to resolve the problem. The hotfix decreases the time, but if you want to get Down to a very low timeout, you need to adjust global TCP parameters.



Here is what you need to do.



Connection Timeout parameter has been implemented in

KB 2836543 6.0.1108.4445 (Dynamics AX 2012 RTM)

and 6.2.1000.1869 (Dynamics AX 2012 R2).



Additionally you need to apply a Windows hotfix to get the InitailRtO parameter added.

Install the Windows hotfix from this KB article: http://support.microsoft.com/kb/2472264

Set the Initial RTO
value,
as described in the above KB. Note this warning in the article:

Warning
: Setting a low value of Initial RTO could result in
failure to connect.

During our testing, we tested with values as low as 300 msec (netsh interface tcp set global initialRto=300) and didn’t see any
problems. They may need to adjust this value a few times to find the setting that is right in your environment.

POS.EXE.CONFIG Example






<span style="background-color: #ffffff;">