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.