Stephen W. Thomas BizTalk Blog

100% Pure BizTalk
posts - 133, comments - 195, trackbacks - 427

My Links

News

Subscribe to my blog via:


Add to Google

Visit my website at:
www.BizTalkGurus.com

Archives

BizTalk 2004 Samples

BizTalk 2006 Samples

BizTalk Videos

BizTalk White Papers

BizTalkBlogs.com

Great BizTalk Blogs

Other Links

Large Messages and Large Maps in BizTalk 2004

Updated 8/8/2005:
Please note the information below is outdated and I would never recommend mapping messages of this size inside Biztalk 2004.  Biztalk 2006 will have support for larger messages by breaking up the message into chunks.  More information on large message support can be found on the Performance Blog.

 

Original Post:

 

Ok, I hear it all the time: “Can BizTalk handle large files?” 

 

But, really the question should be: “How large of a file do you want BizTalk to process?”

 

Large is a subjective term.  For the purposes of this post, large is a 150 MB XML Document.  I see lots of blogs with negative posts on big messages in BizTalk 2004.  My experiences have been quite the opposite.  But, I’ll let you make the determination yourself.  Here are my test results.

 

My Test Computer: P4 2.4 GHz with 1.25 GB Ram.

 

CRITICAL: Working with large files such as this will consume a HUGE amount of system resources.  My CPU was maxed at 100% and RAM utilization was extensive.  A better approach is to break the large file down, but that is a subject for another post coming soon…

 

Sample File Size: 180 MB

Schema Nodes: Around 400

All Mapping on Send Port, map size is around 1.2 MB

 

Test1: Straight line mapping to itself

Run Time: 7 minutes 13 seconds

 

Test2: Straight line mapping to itself

Functoids: Around 80 String Manipulation

Run Time: 8 minutes 26 seconds

 

Test3: Straight line mapping to itself

Functoids (over 250):

-          Around 80 String Manipulation

-          Around 50 Logical

-          Around 50 Value Mapping

-          Around 80 Scripting with calls to an external assembly

Run Time: 9 minutes 42 seconds

 

Take Away: I was surprised and impressed with the processing time of large files inside BizTalk.  But, I’ll let you make the final determination…

Print | posted on Tuesday, August 17, 2004 9:37 PM |

Feedback

Gravatar

# re: Large Messages and Large Maps in BizTalk 2004

Stephen,
It is interesting how you contest the size limitations of BTS04 (judging from my experience & from other feedbacks) by providing these statistics. I find it quite hard to believe that 180 mb file with the amount of mapping & functoid processing successfully processed in the time you specified. I find this hard to believe for two reasons.

1) BizTalk does all mapping or functoid processing in memory. So if you have a 180 mb "complex" file to map, BizTalk is going to be doing all that processing in memory which will eventually lead to OutOfMemory exception.

2) You do not provide any working example or idea on how your architecture is laid out. So, that leaves me to believe that you are just guessing/estimating this answer.

I have tested over & over again the OutOfMemory issue, and it always concludes that it is in the map w/ a maximum file size limit of roughly 150,000 rows/12mb.

Think memory is a problem? Well, I have BizTalk 04 running on dell poweredge 2650 w/ 2gig ram & dual Xeon processors. Plus, the db server is remote running on dell 6650 quad Xeon processors & 4gig memory. Now, I highly doubt that BTS04 is going to need any more memory then that let alone utilize it all.

My whole point to this retorted message is that the MS BizTalk Team has been lying to the community by telling us that BTS04 has been re-engineered to handle what its predecessor BTS02 couldn't; large ff message conversions. (Over 100mb)

However, when I presented my problem to the MS Team and asked why the file couldn't convert, their answer was due to the maps in memory. The size (if mapped) should be shrunk to a smaller size.

If you have really achieved this large file mapping successfully, then provide an example, else, I would change your blog because there are too many gaps in the truth about BTS04.

Jason
jworkman1[at]comcast.net
2/13/2005 12:52 PM | jworkman[at]comcast.net
Gravatar

# re: Large Messages and Large Maps in BizTalk 2004

I have been working against MS Support now for nearly 3 months regarding the SOAP Adapter in BTS 2004 and OOM-errors with handling large files.

My last response from MS is that due to very fundamental architecture-issues in the .NET-framework, the support for large files in BTS 04 is limited to 10mb. Any bigger files than that are not supported.

Given that my data-files are typically in the 100mb plus category, this is not very acceptable.

But, as Stephen is only testing mapping using the File-Adapter, I have also managed to map files in the 100mb plus category successfully. The issues come when you try to use the SOAP-adapter or the SQL Adapter for transport the messages.

So I suggest that Stephen add this as additional information on his blog

Rgrds
Terje Andersen
3/10/2005 8:23 AM | Terje Andersen
Gravatar

# re: Large Messages and Large Maps in BizTalk 2004

Hello.

Excellent point. This post is a little old and out dated. I will work on posting an update shortly.

It is important to note these tests were ran using the file adapter and without any other load on the system. Plus, I was using a pure messaging solution. This type of solution will allow for larger message processing. I know that now, but did not know that 9 months ago when I wrote this post.

Large message support and OOM (Out of Memory) Exceptions are covered well in this post: http://blogs.msdn.com/biztalk_core_engine/archive/2005/02/28/381700.aspx

On the SOAP messages, can you send the payload as a WSE-2 Attachment?

Thanks for the comments.

Stephen W. Thomas
3/10/2005 11:47 AM | Stephen W. Thomas
Gravatar

# re: Large Messages and Large Maps in BizTalk 2004

But, as Stephen is only testing mapping using the File-Adapter, I have also managed to map files in the 100mb plus category successfully. The issues come when you try to use the SOAP-adapter or the SQL Adapter for transport the messages
7/24/2008 3:49 PM | sesli
Gravatar

# re: Large Messages and Large Maps in BizTalk 2004

I'm really surprised, Biztalk takes 3 hrs to process 8 MB data on my system. Can you please tell me what's the magic?
5/26/2009 6:15 AM | AJ
Gravatar

# re: Large Messages and Large Maps in BizTalk 2004

This depends on a lot of factors including schema complexity, number of records, disk space, host layout, etc. But in general that seems slow. Not sure how to start looking into the problem though without some more details.

Stephen W. Thomas
6/16/2009 10:31 PM | Stephen W. Thomas
Post A Comment
Title:
Name:
Email:
Website:
Comment:
Verification:
 

Powered by: