Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Websphere Application Server lags with multiple connections

Posted on 2011-02-28
6
Medium Priority
?
453 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 2000 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

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

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

This exercise is about for the following scenario: Dmgr and One node with 2 application server. Each application server contains it owns application. Application server name as follows server1 contains app1 server2 contains app1 Prereq…
This article is about some of the basic and important steps to be used to improve the performance in web-sphere commerce application development. 1) Always leverage the Dyna-caching facility provided by the product 2) Remove the unwanted code …
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

715 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