Hi
If it is easy to reproduce can you share some thread dump when it happens
please?
Le 23 juil. 2015 16:36, "Steve Singer" <[email protected]> a écrit :
> We are using TomEE (Tomcat with OpenEJB) to connect to a SQL Server
> database.
> The connection works fine, but we are seeing odd CPU creeping issues. The
> application runs and performs well for about 24 hours (SQL Server CPU at
> about 15%-20%), and then performance starts to suffer after that. We check
> and the CPU is now at 60%. If we shut down the running jobs (but leave
> Tomcat running), the CPU drop down to almost zero. If we restart the
> processing, the CPU jumps back up immediately to the 60%. If we stop the
> Tomcat instance and then restart, then the CPU usage on the SQL Server
> machine stays at its low usage for about 24 hours and then it begins to
> creep back up again.
>
> I think that this must be due to the datasource configuration, but I'm not
> sure what changes we should make. Can someone help out? Here is the
> datasource configuration we are using:
>
> <Resource id="Datasource" type="javax.sql.DataSource">
> accessToUnderlyingConnectionAllowed = false
> defaultAutoCommit = true
> ignoreDefaultValues = false
> initialSize = 0
> jdbcDriver = com.microsoft.sqlserver.jdbc.SQLServerDriver
> jdbcUrl = jdbc:sqlserver://{url}
> jtaManaged = true
> maxActive = 200
> maxIdle = 20
> maxOpenPreparedStatements = 0
> maxWaitTime = -1 millisecond
> minEvictableIdleTime = 30 minutes
> minIdle = 0
> numTestsPerEvictionRun = 3
> password = {password}
> passwordCipher = Static3DES
> poolPreparedStatements = false
> testOnBorrow = true
> testOnReturn = false
> testWhileIdle = false
> timeBetweenEvictionRuns = -1 millisecond
> userName = {user}
> validationQuery = SELECT 1
> </Resource>
>
> Thanks in advance!
>
>
>
> --
> View this message in context:
> http://tomee-openejb.979440.n4.nabble.com/TomEE-Datasource-Connection-to-SQL-Server-CPU-Creep-tp4675573.html
> Sent from the TomEE Users mailing list archive at Nabble.com.
>
