Load on BizTalk Server by using SQL Adapter RRS feed

  • Question

  • Hi, I am using SQL Adapter to fetch details by passing one parameter. I have 7 Integrations in total which use SQL Adapter. Is it fine to use SQL Adapter. How feasible is it and would it hamper BizTalk environment performance. Say at a single moment, we have 3500 BizTalk instances quering the database using SQL adapter.Is it feasible. ( This is the worst case scenario in my case ) Thanks in Advance. Regards, Sachin.
    Tuesday, May 5, 2009 10:22 PM


  •  It should not, but it would be nice have a separate host configured for SQL Processing. So that way your Recv/Send/Orchestration processing don't share the same process with SQL. Even if you want scale later it will handle more transaction it should hold good.

    - SHR
    Monday, May 11, 2009 9:00 PM