BizTalk Server Applications Integration - SQL adapter performance is very slow

Author

SQL adapter performance is very slow

Niklas E

2004-11-11, 5:49 pm

Some of our files are split into a lot of smaller files, e.g. one message
per product/customer etc, because else BizTalk will lock the whole database
for other users and if something goes wrong, then all products/customers are
rolled back instead of only the problematic. This is not such a problem, but
in our case I have noticed that BizTalk is very slow with transactions when
doing this. When I turned off transaction support, the throughput increased
about 100 times. Am I missing some setting with the transactions or is it
supposed to be like this?

Best regards
Niklas E