BizTalk Server Applications Integration - SQL Server Adapter deadlock

Author

SQL Server Adapter deadlock

Berni

2004-03-18, 2:00 pm

Hi,

I store information to an SQL Server Database on the same
machine. And I have the Problem that if the message will
be received in a single second the BizTalk returns an
error that the transmission attempt failed. How ever after
one or more retries it will be stored. On a third test
server no errors will be returned. I thought the load on
the server is the problem and therefore I increased the
waiting period for receiving new messages. This worked
fine for a couple of weeks. Now the problem arose again.
What is the best practice to cope this warning/error?

Kind Regards