Tomcat and Connection pool size question
From: paddymee (paddymee_at_yahoo.com)
Date: 03/29/04
- Next message: org: "problem with GROUP BY..."
- Previous message: marty: "silly problem with If statement - JSP/AS400 access"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: 29 Mar 2004 12:53:37 -0800
Hi all.
I have Tomcat 4.1.18 talking to a SQL Server 2000 DB via a connection
pool. I have configured MaxIdle and Max active to be both 150. I don't
exactly know the version number of the JDBC drivers, but I know for
sure they are not SP2.
However if I run
select hostname,count(*) from sysprocesses
group by hostname order by hostname
I notice that the main servers have over 300 connections and the quite
servers have much fewer than 150 connections.
So why do some servers have too many connections and some servers too
few?
Are MaxIdle and MaxActive just guidelines?
I will need to have a justification to upgrade to SP2. I can't find
any mention that they will fix this. So and pointers would be great.
Thanks,
Paddy
- Next message: org: "problem with GROUP BY..."
- Previous message: marty: "silly problem with If statement - JSP/AS400 access"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
