SAS WebApplication Server DB connections

[sandeep_reddy]

Hello Everyone,

I need your suggestion in monitoring the slowness from WebApplication servers, particulalry with SASServer1_1 and SASServer8_1 JVM's.

We have resource crunch at DB side, when this happens JVM's are slow and at times not responding to any user requests. 

Well, this is a know issue for us, but the question here is , when this happens , the JDBC connections which are already connected to DB should be closed after sometime. These sessions are not getting closed automatically , i need to restart the JVM's to resolve this issue. 

Any suggestions to close this sessions without restarting the JVM would be highly appreciated.

Thanks In Advance,

Sandeep