Skip to Content
avatar image
Former Member

Sender JDBC adapter slow processing in Production

Hi All,

We are facing an issue with processing time for Sender JDBC adapter.

We tested a scenario in Quality for JDBC to Proxy. In quality the Sender JDBC adapter is taking around 30-50 sec. to send data to PI, but in production the JDBC adapter is taking more then 7 mins to send the same amount of data from DB to PI.

We have checked the setting in PI; it is same in both the systems (Q and P).

Even the parameters for both the servers maintained same.

Can any body please suggest the reason of this behavior and any workaround?

Regards,

Rahul

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 12, 2009 at 02:38 PM

    Based on my experience, these are the things that could be used to improve JDBC performance

    1. You may increase the thread count for JDBC related queues. This has to be done in accordance with SAP Note 1084161.

    2. There is parameter in JDBC communication channel called Maximum Concurrency. It signifies that one communication channel can make how many connections to database. This is 1 by default and could be increased to some values like 3-4.

    3. In the Visual Admin/ NWA, there is a parameter called as queueParallelism.maxReceivers which defines the number of parallel worker threads for one receiver channel instance. This should be done following SAP Note 1136790. This can be done along with the first point.

    Regards,

    Prateek

    Add comment
    10|10000 characters needed characters exceeded