• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Connection Pooling. Performance Tuning

 
Greenhorn
Posts: 23
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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?
 
Ranch Hand
Posts: 8945
Firefox Browser Spring Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
May be this performance tuning article will help
http://www.javaperformancetuning.com/tips/jdbcconnpool.shtml
 
Ranch Hand
Posts: 724
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Ranch Hand
Posts: 1312
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Ranch Hand
Posts: 1209
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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

 
reply
    Bookmark Topic Watch Topic
  • New Topic