Solved

Websphere Application Server lags with multiple connections

Posted on 2011-02-28
6
452 Views
Last Modified: 2012-05-11
Hello experts

I have an application running in Websphere 6.0, Linux SUSE Enterprise 9 SP2 (server A) that makes db2 queries to another server (server B). During the development stage, everything seemed to be working just fine. The problem came when doing traffic tests: when creating between 80-100 concurrent http requests to the WAS app, the application just stops answering, where:

- CPU consumption in server A is less than 20% when doing volume tests (we have a good server)
- Memory still available during volume tests (around 50% from total used)
- When reaching around 80-100 http requests, the application server lags, even trying to enter the administrative console is greatly slowed down, I need to restart the whole WAS from the terminal re-establish it. Looks as if threads don't want to be resolved when the queue reaches certain volume of requests.
- All other applications installed in the Application Server are affected, even if the others aren't doing anything at all.
- There are no errors detected in the SystemErr.log
- "Server B" is not the problem (there are many other servers consulting db2 to that server without any problem.
- No network issues
- Websphere Application Server has base configuration (as installed)

My first assumption is that there is a parameter in the WAS configuration that I need to change (number of threads? max memory consumption for WAS threads? Max Clients?) but I'm a newbie with WAS (used to work with Tomcat). Resources like memory (currently 3GB) and CPU can be added without problem

Any suggestions are greatly appreciated
0
Comment
Question by:Arrismog
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 41

Expert Comment

by:HonorGod
ID: 35006599
It sounds like you have exceeded the number of concurrent connections.

Take a look here: http://bit.ly/gJ9IUz
especially the part about "Maximum Connections"

How many do you currently have allowed?
0
 

Author Comment

by:Arrismog
ID: 35023768
Hello

Checking the value for Maximum Connections, they are currently set to 10:

Connection timeout -- 180 seconds
Maximum connections -- 10 connections
Minimum connections -- 1 connections
Reap time -- 180 seconds
Unused timeout -- 1800 seconds
Aged timeout -- 0 seconds

Is Maximum connections too low? there's an estimate to have hundreds of requests per minute to this application.

0
 
LVL 41

Accepted Solution

by:
HonorGod earned 500 total points
ID: 35027349
Maximum connections defines the absolute maximum number of concurrent connections that are allowed to that database.  If your applications need more than 10 concurrent connections, I would increase this value accordingly.

So, to answer your question:

> Is Maximum connections too low?

Yes, it appears so.
0
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 

Author Comment

by:Arrismog
ID: 35101310
Sorry answering till now, we were in functionality and stress phase with the app.

Yep, increasing the maximum connections according to the link you provided, it now supports a lot (LOT) more connections without any problem

Sir, you made my day :)
0
 

Author Closing Comment

by:Arrismog
ID: 35101313
Yep, increasing the maximum connections according to the link you provided, it now supports a lot (LOT) more connections without any problem

Sir, you made my day :)
0
 
LVL 41

Expert Comment

by:HonorGod
ID: 35107841
Super!  I'm glad that I was able to be of some assistance.

Thanks for the grade & points.

Good luck & have a great day.
0

Featured Post

Want Experts Exchange at your fingertips?

With Experts Exchange’s latest app release, you can now experience our most recent features, updates, and the same community interface while on-the-go. Download our latest app release at the Android or Apple stores today!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Most of the developers using Tomcat find it easy to configure the datasource in Server.xml and use the JNDI name in the code to get the connection.  So the default connection pool using DBCP (or any other framework) is made available and the life go…
It is possible to boost certain documents at query time in Solr. Query time boosting can be a powerful resource for finding the most relevant and "best" content. Of course the more information you index, the more fields you will be able to use for y…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…

615 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question