none
BizTalk Server -Message Box RRS feed

  • Question

  • Hi,

    I am using BizTalk Server 2013, I would like to know if BizTalk uses connection pooling to the message box?

    if it can, but is not set to use it by default, how can it be enabled?

    Thanks for your time!


    kk.12

    Wednesday, June 17, 2015 9:35 PM

Answers

  • Now its time to refer Microsoft BizTalk Server 2013 Performance Optimization Guide for your BizTalk farm, to find out the available tuning options.

    There is a similar post on this, I am sure you would have checked it before just in case.

    If SQL is the bottleneck here , following few options

    • RAID Level of Disks
    • Separation of data and log files on different drives
    • Splitting temp DB to multiple file groups

    All are covered in details in the optimization guide.

    Have a look please.


    Greetings,HTH
    Naushad Alam

    When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, and/or Mark As Answer
    alamnaushad.wordpress.com

    • Marked as answer by Angie Xu Tuesday, June 30, 2015 6:06 AM
    Thursday, June 18, 2015 4:02 PM
    Moderator
  • Could you please suggest how to overcome latency issues and improve performance.-->

    • Are you using Orchestrations also? --> Check the persistance  points in the orchestration .
    • If not then it seems like you are using aSync Pattern to request/response processing?

    Few things to check

    1. What is the response time from DB2?
    2. How is your map performing ? I would using custom xslt in map rather than using functoids. Depends upon the complexity of the schema. 
    3. Are you using any custom pipeline ? Check if you can use pass thru instead xml receive/send
    4. Did you change mxReceiveInterval from default to somewhere 250. Check Low-Latency Scenario Optimizations page for more details 


    Greetings,HTH
    Naushad Alam

    When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, and/or Mark As Answer
    alamnaushad.wordpress.com

    • Marked as answer by Angie Xu Tuesday, June 30, 2015 6:06 AM
    Thursday, June 18, 2015 7:30 PM
    Moderator

All replies

  • So, the question is irrelevant...:)

    You cannot change in any way how BizTalk Server interacts with the databases which it owns.

    Are you having a specific problem we can help you out with?

    Thursday, June 18, 2015 2:09 AM
    Moderator
  • Hi ,

    Is there any specific issue you are encountering .As been suggested by boat seller ,you can not change the way how biz talk interacts with its DB .

    We should be more concentrate to the solutions which we need to develop with BizTalk as Integration hub.

    Thanks
    Abhishek

    Thursday, June 18, 2015 4:34 AM
  • Thank you!

    We have been facing latency issues on BizTalk Server

    Observations from our PAL BizTalk Analysis :

    • Greater than 2 logins per second - this may indicate that applications are not correctly using connection pooling (this triggered the question)
    • Greater than 2 logouts per second - this may indicate that applications are not correctly using connection pooling
    • BizTalk: An increasing trend of more than 10 idle orchestrations per hour
    • An increasing trend of more than 10 MB per hour in .NET CLR Memory
    • BizTalk message latency exceeds 10 seconds
    • BizTalk message outbound adapter latency exceeds 10 seconds
    • ASP.NET execution times are greater than 8 seconds
    • Greater than 25 ms physical disk READ response times (max=0.041)
    • A ratio of more than 1 SQL Compilation for every 100 Batch Requests per second

    Overview of our BizTalk Application

    • Receive web service request using SOAP adapter
    • Transform in BizTalk
    • Send request to DB2 using DB2 adapter
    • Receive response from DB2
    • Transform in BizTalk
    • Send web service response to user

    Could you please suggest how to overcome latency issues and improve performance.

    Thanks!


    kk.12


    • Edited by K.12 Thursday, June 18, 2015 4:31 PM
    Thursday, June 18, 2015 3:52 PM
  • Now its time to refer Microsoft BizTalk Server 2013 Performance Optimization Guide for your BizTalk farm, to find out the available tuning options.

    There is a similar post on this, I am sure you would have checked it before just in case.

    If SQL is the bottleneck here , following few options

    • RAID Level of Disks
    • Separation of data and log files on different drives
    • Splitting temp DB to multiple file groups

    All are covered in details in the optimization guide.

    Have a look please.


    Greetings,HTH
    Naushad Alam

    When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, and/or Mark As Answer
    alamnaushad.wordpress.com

    • Marked as answer by Angie Xu Tuesday, June 30, 2015 6:06 AM
    Thursday, June 18, 2015 4:02 PM
    Moderator
  • Can you let us know exactly what kind of 'issues' you're facing?
    Thursday, June 18, 2015 5:36 PM
    Moderator
  • Could you please suggest how to overcome latency issues and improve performance.-->

    • Are you using Orchestrations also? --> Check the persistance  points in the orchestration .
    • If not then it seems like you are using aSync Pattern to request/response processing?

    Few things to check

    1. What is the response time from DB2?
    2. How is your map performing ? I would using custom xslt in map rather than using functoids. Depends upon the complexity of the schema. 
    3. Are you using any custom pipeline ? Check if you can use pass thru instead xml receive/send
    4. Did you change mxReceiveInterval from default to somewhere 250. Check Low-Latency Scenario Optimizations page for more details 


    Greetings,HTH
    Naushad Alam

    When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, and/or Mark As Answer
    alamnaushad.wordpress.com

    • Marked as answer by Angie Xu Tuesday, June 30, 2015 6:06 AM
    Thursday, June 18, 2015 7:30 PM
    Moderator