Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (3)

Resolved Powerserver active session count doesn't match database connection count

  1. Issue
0
Votes
Undo
  1. William Nevins
    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

Existe Algún Video de PowerServer 2021?
Error occur when using PowerBuilder 2021 to build...
Responses (3)
William Nevins
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
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
Armeen Mazda @Appeon
  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
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
Chris Pollach @Appeon
  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.