Re: Database log in

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.