I don't have a problem with hundreds or
thousands of logins per minute on RDS or bare metal, even with only 8
CPUs and 32GB RAM. There is something else in play here...
David G. Johnston wrote on 1/24/2024 4:34 PM:
On Wednesday, January 24, 2024, Heckler, Kim M <kim.heckler@xxxxxxxxxxxxxx> wrote:
My questions are around what happens at log in
time; what are the sequence of events? Also, how much “stress” does log
in have to the DBMS?
A decent amount.
How many concurrent logins can the
DBMS handle in a short time frame? Can 40 sessions be initiated within
90 seconds? 60 seconds?
It depends.
Please, I would appreciate debugging suggestions.
Don’t? At this point you’ve probably hit the point where
connection pools are the best way forward. Especially since 8 is much
less than 40.
David J.
|
