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@nationwide.com> 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.