SAS WebApplication Server DB connections

sandeep_reddy — Tue, 21 Nov 2023 05:57:54 GMT

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

topic SAS WebApplication Server DB connections in Administration and Deployment

SAS WebApplication Server DB connections