Performance Tunining

[Former Member]

What are all the components that we have to monitor, that will cause a Performance Issue.

We are having some issues with our File and JDBC adapters quite frequently. Our production queues are often slow.

If there is a how to guide to setup the number of thread in the Visual Admin?

Thanks

[prateek]

The components that hamper performance in XI totally depends upon the design of ur scenario.

e.g. in ur scenario a frequent call to database generally reduces the performance.

Other factors could be use of BPM, frequent JDBC or RFC lookups, large volumes of data, large size of individual messages or records. extensive mappings etc.

U can search sdn directly for the performance tuning guides.

Regards,

Prateek

[Former Member]

Hi,

Are you using stored procedure or sql select query ?

If it is a sql select query then try switching to stored procedures.

check these parameters too.........

Transaction Isolation Level -> default

Disconnect from Database After Processing Each Message -> set the indicator.

Performance tuning Guide:

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/70ada5ef-0201-0010-1f8b-c93...

Also for overall tuning

http://help.sap.com/bp_bpmv130/Documentation/Operation/TuningGuide.pdf

Refer this guides..

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/423f5046-0a01-0010-2698-b2dc7c31...

regards

biplab