So we have gone and exceeed the allowed SQL connections, resulting in timeouts.
Searching the code I see tons of places connections are opened but not disposed or closed.
Are they being closed somewhere else?
Mainly during checkout and login events.
My question how do i fix this ?
Under a high load there are no connections available, and users are awaiting a connection.
Is there a way to force close/dispose connections after (x amount of time) besides hunting down every bit of code that opens a connection and force closure ?
I see tons of new connections but no