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?
-Russell Waltz
Yes. I use SQL Adapter. The stored procedure is doing well, the exution takes only ten milliseconds, but 20 executions every five minutes.
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?