Hi all,
I have a BizTalk solution deployed at a customer site. (BizTalk 2006 R2 with the non WCF adapters) One of the orchestrations issues an RFC call to a SAP system and returns a big message. The message is mapped to a SQL Adapter Send Port schema which is calling a stored procedure.
Recently I'm running into a OutOfMemory exception when the message is sent to the SQL Adapter. I did a trace with SQL profiler which resulted in a 90MB+ tracefile for just a few seconds. As I imagined, the Stored Procedure is executed rapidly one after another.
But even this does not explain why I get the error message. The Server has 32GB RAM and I can't even see it peaking out...
Any suggestions what else I could check?