IDLE Session and Its Impact on Total Active Sessions

skarangi
SQL-Fighter

Hi, 

Does Exasol  considers IDLE session as active session? If no , at what point should  we worried about number of IDLE sessions?

Regards,
Sreekanth

Capture1.PNG

 

Capture.PNG

1 ACCEPTED SOLUTION

kristof
SQL-Fighter

Hi Sreekanth,

IDLE sessions are not considered as active sessions. I think you're fine with your amount of idle sessions. I've seen way more with a still fine-performing system.

Here's a short article about session management which I think is quite interesting for you: https://docs.exasol.com/database_concepts/session_management.htm

Best regards,

Kristof

View solution in original post

1 REPLY 1

kristof
SQL-Fighter

Hi Sreekanth,

IDLE sessions are not considered as active sessions. I think you're fine with your amount of idle sessions. I've seen way more with a still fine-performing system.

Here's a short article about session management which I think is quite interesting for you: https://docs.exasol.com/database_concepts/session_management.htm

Best regards,

Kristof

View solution in original post