Server Connections on Start-up

[Former Member]

All:

For a variety of possible reasons we routinely have to re-start our xMII web server when java.exe consumes all available CPU. We believe that a custom application that runs BLS transactions against the server has some unbounded java code that allows java.exe to consume all CPU. We're not really sure how to resolve that issue, but have another concern from our system re-start logs.

When starting up connections to external databases, we observe in the general log that there are large numbers of connection objects that appear to instantiate for each external database server connection (example below). Have we overlooked some clean-up configuration that will eliminate this and secondly, does this log entry imply connection pool or other resource consumption that could adversely impact performance?

Thanks in advance.

Dave

Created Connection pool [jdbc:inetdae:HXXXXXXXXXX:1433?database=ProdP&sql7=true]: ConnectionObject[con=com.inet.tds.e@166340c,inUse=false,useCount=0] ConnectionObject[con=com.inet.tds.e@e33e18,inUse=false,useCount=0] ConnectionObject[con=com.inet.tds.e@101ac93,inUse=false,useCount=0] ConnectionObject[con=com.inet.tds.e@e90943,inUse=false,useCount=0] ConnectionObject[con=com.inet.tds.e@15f1f9c,inUse=false,useCount=0] ConnectionObject[con=com.inet.tds.e@1474ea,inUse=false,useCount=0] ConnectionObject[con=com.inet.tds.e@107bd0d,inUse=false,useCount=0] ConnectionObject[con=com.inet.tds.e@10ca208,inUse=false,useCount=0] ConnectionObject[con=com.inet.tds.e@61f533,inUse=false,useCount=0] ConnectionObject[con=com.inet.tds.e@12922f6,inUse=false,useCount=0] ConnectionObject[con=com.inet.tds.e@1b66b06,inUse=false,useCount=0] ConnectionObject[con=com.inet.tds.e@12c9557,inUse=false,useCount=0] ConnectionObject[con=com.inet.tds.e@9f0d,inUse=false,useCount=0] ConnectionObject[con=com.inet.tds.e@ca3783,inUse=false,useCount=0] ConnectionObject[con=com.inet.tds.e@2a6ff,inUse=false,useCount=0] ConnectionObject[con=com.inet.tds.e@21d23b,inUse=false,useCount=0] ConnectionObject[con=com.inet.tds.e@7124af,inUse=false,useCount=0] ConnectionObject[con=com.inet.tds.e@1f7708,inUse=false,useCount=0] ConnectionObject[con=com.inet.tds.e@1bfbfb8,inUse=false,useCount=0] ConnectionObject[con=com.inet.tds.e@1c3e9ba,inUse=false,useCount=0] ConnectionObject[con=com.inet.tds.e@125d61e,inUse=false,useCount=0] ConnectionObject[con=com.inet.tds.e@10c6cfc,inUse=false,useCount=0] ConnectionObject[con=com.inet.tds.e@c72243,inUse=false,useCount=0] ConnectionObject[con=com.inet.tds.e@19a8416,inUse=false,useCount=0] ConnectionObject[con=com.inet.tds.e@155d3a3,inUse=false,useCount=0] ConnectionObject[con=com.inet.tds.e@1b994de,inUse=false,useCount=0] ConnectionObject[con=com.inet.tds.e@dc9766,inUse=false,useCount=0] ConnectionObject[con=com.inet.tds.e@57e787,inUse=false,useCount=0] ConnectionObject[con=com.inet.tds.e@1217e67,inUse=false,useCount=0] ConnectionObject[con=com.inet.tds.e@1f1bd98,inUse=false,useCount=0] ConnectionObject[con=com.inet.tds.e@1d686c1,inUse=false,useCount=0] ConnectionObject[con=com.inet.tds.e@128edf2,inUse=false,useCount=0] ConnectionObject[con=com.inet.tds.e@1dddba,inUse=false,useCount=0] ConnectionObject[con=com.inet.tds.e@c7e8a7,inUse=false,useCount=0] ConnectionObject[con=com.inet.tds.e@7b4703,inUse=false,useCount=0] ConnectionObject[con=com.inet.tds.e@1732ed2,inUse=false,useCount=0] ConnectionObject[con=com.inet.tds.e@1071521,inUse=false,useCount=0] ConnectionObject[con=com.inet.tds.e@1fc3c84,inUse=false,useCount=0] ConnectionObject[con=com.inet.tds.e@e93999,inUse=false,useCount=0] ConnectionObject[con=com.inet.tds.e@1c486f2,inUse=false,useCount=0] ConnectionObject[con=com.inet.tds.e@1779885,inUse=false,useCount=0] ConnectionObject[con=com.inet.tds.e@be76c7,inUse=false,useCount=0] ConnectionObject[con=com.inet.tds.e@682406,inUse=false,useCount=0] ConnectionObject[con=com.inet.tds.e@115126e,inUse=false,useCount=0] ConnectionObject[con=com.inet.tds.e@6d2380,inUse=false,useCount=0] ConnectionObject[con=com.inet.tds.e@135b1f3,inUse=false,useCount=0] ConnectionObject[con=com.inet.tds.e@35e6e3,inUse=false,useCount=0] ConnectionObject[con=com.inet.tds.e@c9630a,inUse=false,useCount=0] ConnectionObject[con=com.inet.tds.e@185572a,inUse=false,useCount=0] ConnectionObject[con=com.inet.tds.e@11daa0e,inUse=false,useCount=0]

[Former Member · Accepted solution]

What is your PoolSize and PoolMax setttings for this datasource?

[Former Member · Accepted solution]

Thanks for the quick replies guys. Where do we find the PoolsizePoolMax settings?

Dave

[salvatore_castro · Accepted solution]

David,

The data server configuration, the default should be 100, which is typically more than you need. You may want to investigate "why" this is occurring instead of how to "fix" this one. There may be a design flaw in the usage of xMII causing this to happen. Hope this helps.

-Sam

[Former Member · Accepted solution]

Yes, thaks Sam. We believe the design issue is one that we need to pursue. We'll do some more investiagtion.

Thanks again all.

Dave

[salvatore_castro]

Do you have something set in the scheduler that's establishing these connections?

-Sam