• Post Reply Bookmark Topic Watch Topic
  • New Topic

Connection Pooling. Performance Tuning  RSS feed

 
Mayuri Roi
Greenhorn
Posts: 23
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What is the max connection Pool setting would be ideal if I am expecting around 300 concurrent users and 10,000 overall users are going to hit the websphere application?
I have 10 GB of RAM & Dual Processor.

What would be ideal JVM heap size?

What should be the DB2 settings such as #of Max Agents settings?
 
Pradeep bhatt
Ranch Hand
Posts: 8933
Firefox Browser Java Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
May be this performance tuning article will help
http://www.javaperformancetuning.com/tips/jdbcconnpool.shtml
 
David Ulicny
Ranch Hand
Posts: 724
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Maximum connection pool size 80. This should be enough, but I suggest you should monitor you application.

I don't understand what you mean by ideal JVM heapsize.
 
somkiat puisungnoen
Ranch Hand
Posts: 1312
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What would be ideal JVM heap size?


If you want to setup size of memory of Server on start server, you can use -xms in startup config file.
 
Karthik Guru
Ranch Hand
Posts: 1209
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by David Ulicny:
Maximum connection pool size 80. This should be enough, but I suggest you should monitor you application.


Just curious how did you arrive at this figure? Is there a websphere recommended way of calcuating the connections in the pool?.

I think in weblogic, they say

(Number of threads in the execute queue) x 2

Somebody needs to confirm this though.

Now if there are 300 concurrent users, more the cpu the better.
Now am not sure what w'd be the optimal thread pool value for 300 concurrent users in weblogic. If each operations take a long time to respond, then that thread will be blocked and other users w'd have to wait.
 
Mayuri Roi
Greenhorn
Posts: 23
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks for the replies.

This might sound little dumb. But, this is what we faced. When there are 300 concurrent users, our system is getting really slow. Right now we have 200 connection pool setting in websphere and around 4GB for max heap size.

At the same time when there are 150 concurrent users, our system is handling the requests pretty good.

in Db2. Max agents = 200.

Anytihng else should I configure to make 300 concurrent users run smoothely??
 
David Ulicny
Ranch Hand
Posts: 724
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

Just curious how did you arrive at this figure? Is there a websphere recommended way of calcuating the connections in the pool?.


In our application which is running 290 users is this value enough. Maybe a little bit greater than it should be. I'm doing daily observation of the application with PMI. I could say you that average value of concurently used connection in the pool is around 3. Max value is around 20.

We have also problems with performance.
Do the following:
Monitor the application and find the bottlenecks.
Monitor the SQL queries.

How many HTTP threads there are running?
How many WebContainer threads?
 
somkiat puisungnoen
Ranch Hand
Posts: 1312
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Anytihng else should I configure to make 300 concurrent users run smoothely??


You should be created in Clustering Server for more avaibility...
 
somkiat puisungnoen
Ranch Hand
Posts: 1312
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
How many HTTP threads there are running?
How many WebContainer threads?


Depend on your configuaration :

Example :

In WebSphere/Web Logic you can config Thread Pool in server .


Allow thread allocation beyond maximum
Property name in the Java-based administrative console
Allows the number of threads to increase beyond the maximum size configured for the thread pool
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!