We have an orchestration BizTalk, which allows replication of data from a third-party server to an SQL 2005 server. Replicated data is written on the destination server through a stored procedure. Frequency of this writing procedure is 20 per 5 minutes.Do you know of any parameterization that could explain such phenomenon ?
So are you saying that you are importing a large batch of data and it is going slowly? Are you using the SQL adapter? Have you performance tested the stored proc to make sure it’s not the bottleneck?
What is your whole process? Are you using an orchestration, messaging, etc? Is there anything else in the process that could be a bottleneck? Are you sure that BizTalk is receiving all of the files at once, or are they trickling in? Are you using any other adapters than the SQL adapter?
Author
Posts
Viewing 1 reply thread
The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.