skip to main content

SAP NetWeaver Newbie

How to ensure that the database connectivity is not a bottleneck

If your SAP XI application deals with a high volume of messages, you may have tuned the number of ABAP work processes, added server nodes or installed additional Dialog Instances. If you find that there is not much improvement in message processing power check the database logs.

If you find errors like these, the database is not opening enough sessions and is a bottleneck.
Oracle: ORA-00018: maximum number of sessions exceeded 
ORA-00020: maximum number of processes exceeded 
SAP DB: -9807 Task Limit
Here is how you calculate the required number of connections that need to be opened:

Number of connections required for ABAP work processes:
ABAP_connections = 2*(Total number of work processes in all instances) + 20

Number of connections required by J2EE server nodes
J2EE_connections = (Number of Java server nodes)*(Maximum No. of Connections in all DB pools) + 10

You can find out the maximum number of connections as shown in the screen shot. 100 is the default value


Therefore the number of connections required are [2*(Total number of work processes in all instances) + 20] + [(Number of Java server nodes)*(Maximum No. of Connections in all DB pools) + 10]

If you are using Oracle, this number is the number of processes and the number of session = 1.2*(number of processes)

No comments:

Post a Comment

Email Subscription

Get every new post into your inbox by subscribing us.

Want a reason to subscribe?
1. This sitemap might convince you to subscribe.
2. We do not misuse email IDs. We respect privacy.

© 2008 - 2017 sapnwnewbie. All rights reserved.