Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Multiple connection with sql adapter › Re: Multiple connection with sql adapter
December 31, 2008 at 6:00 AM
#21456
If its a requirement to process the messages in order, then implement singleton pattern. Only one instance of orchestration will process the messages.
But if its not, I guess you need analyze the causes for database locks and try to avoid them.
-try using stored procedures
-minimize the scope of database transaction