performance
We have lately been having some performance issues in our application, the garbage collection cycles are OK, the database connection times are fine, heap size usage is good, but some how transactions which should normally 300 ms are taking as long as 1 s.
The interesting thing is that persistance which normally takes longer times is not having any issues either,
Are there anyother areas that I need to look at and am forgetting?
No code change has taken place in this env for about 10 days so that cannot be a problem.
[546 byte] By [
kilyasa] at [2007-11-27 2:38:41]
> What about memory usage on the database server? Is it
> shared with other apps that could be eating up
> resources?
The memory usage ob the DB server side is fine, however its taking long times to grab connections, even MQ is taking longer than usual, the connection pool size is 55, initial size is 20.
avg time for grabbing the connection is 700ms it should be around 60ms
> avg time for grabbing the connection is 700ms it
> should be around 60ms
Pools will often block on a request if the pool is depleted and wait until a connection is available.
If that was the case then one reason you wouldn't have seen it before could be because something now is taking just slightly longer to run - perhaps one often used query for example. On a slight increase in sessions. The increase has reached the upper limit of the pool and thus the depletion.
