1. William Nevins
  2. PowerServer 2020 or older (Obsolete)
  3. Thursday, 11 February 2021 21:12 PM UTC

I've been bumping up against my active session limit in AEM but when I look in the database, I don't see the same number of connections.  Why is that?  I do not have a timeout in AEM since I need certain application functions to be persistent.  For other uses I'm using a timeout in the application that does seem to work.

Should the active session count match the database connection count?

Thanks

William Nevins Accepted Answer Pending Moderation
  1. Tuesday, 16 February 2021 12:43 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 1

Thanks for your help.

Comment
There are no comments made yet.
William Nevins Accepted Answer Pending Moderation
  1. Thursday, 11 February 2021 21:21 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 2

In my case for example, I see 9 database connections but 47 active sessions.  Is this normal?

Comment
  1. Armeen Mazda @Appeon
  2. Thursday, 11 February 2021 23:29 PM UTC
This is normal. It does shared connections between PowerServer and the database.
  1. Helpful
There are no comments made yet.
mike S Accepted Answer Pending Moderation
  1. Thursday, 11 February 2021 21:16 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 3

no it will not.

 

if you are using pooled database connections (the default), it won't even be close.  it should almost always be a lot less.

 

if you are not using pooled connections to the database, then it will be a lot closer, but still would often be off.

 

 

 

Comment
  1. Chris Pollach @Appeon
  2. Thursday, 11 February 2021 22:03 PM UTC
Correct ... this is controlled by your DataSource's MIN / MAX "connection pool size" settings.
  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.