SP execution load

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › SP execution load

Viewing 0 reply threads
  • Author
    Posts
    • #17778

      Hi All,

      Just want to confirm this, we have a Stored procedure that takes a long time to execute, something like 3 to 4 hours, it contains its own logic. If we call it from a biztalk orchestration using the Oracle adapter or a component calling it and we call that component. Once the SP is invoked it obviously executes on the Oracle Server, so all the performance load would be on that server, and the load on BizTalk server would be only that it would be waiting for that call to complete and maintaining the state of that orchestration and nothing else?

      We want to confirm this because if the load of executing SP for three hours is on BizTalk then we'd look for alternate ways of doing this.

       

      Regards,

      Sajid.

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