Hi,
If you are integrating with SQL Server and dealing with batch messages, you may encounter this problem. And this is evitable.
The reason is
the contention
of resources. If your batch contains four messages and all
the four messages have to be updated to SQL Server and then at
the same time four process will contend for SQL server table and resources and
the obvious result will be, few
of your transaction will be left uncomitted and if you are not handling dehydration [not modifying
the default property
of the Dehydration] then your orchestration will dehydrate and will go for retry. If retry is set for every five minutes then after five minutes Port will send
the message to
the database.
Reason for writing this post was as I did not want to see so many DEHYDRATED messages. And this was happening as Host Throttling was not set. Thus as soon as
the BizTalk Process finds that SQL resources are unavailable it will go and dehydrate that process and process will go for retry.
The contension
of resources is unavoidable though we can fine tune
the Dehydration setting. If you increase
the time that an orchestration can be blocked at a subscription before being dehydrated, possibly you will give more time BizTalk Engine to handle to SQL resource availability. At least I solve
the problem by fine tuning
the Dehydration properties. Below is
the section
of config info which you need to add to
the BTSNTsvc.exe.config.
<?xml version="1.0" ?>
<configuration>
<configSections>
<section name="xlangs" type="Microsoft.XLANGs.BizTalk.CrossProcess.XmlSerializationConfigurationSectionHandler, Microsoft.XLANGs.BizTalk.CrossProcess" />
</configSections>
<runtime>
<assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
<probing privatePath="BizTalk Assemblies;Developer Tools;Tracking" />
</assemblyBinding>
</runtime>
<xlangs>
<Configuration>
<Dehydration MaxThreshold="1800" MinThreshold="1" ConstantThreshold="-1">
<VirtualMemoryThrottlingCriteria OptimalUsage="900" MaximalUsage="1300" IsActive="true" />
<PrivateMemoryThrottlingCriteria OptimalUsage="50" MaximalUsage="350" IsActive="true" />
<PhysicalMemoryThrottlingCriteria OptimalUsage="50" MaximalUsage="350" IsActive="false" />
</Dehydration>
</Configuration>
</xlangs>
</configuration>
