Biztalk performance

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Biztalk performance

Viewing 1 reply thread
  • Author
    Posts
    • #19906

      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 ?

    • #19909

      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?

      • #19915

        Yes. I use SQL Adapter. The stored procedure is doing well, the exution takes only ten milliseconds, but 20 executions every five minutes. 

        • #19919

           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?

Viewing 1 reply thread
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.