MS SQL keeps randomly faulting, gateway disconnecting randomly

From this line:

Cannot get a connection, pool error Timeout waiting for idle object

This exception is stating that the pool manager cannot produce a viable connection to a waiting requester and the maxWait has passed therefore triggering a timeout. Usually the issue falls into two broad categories:

  1. The DB is down or unreachable. This could be because you forgot to start it, or it crashed, or the network between you and the DB has stopped working.

  2. The connection pool is out of connections. This could be due to high demand, or it could be an indication of a connection leak where connections are never returned to the pool and eventually you exceed the max connections limit.

1 Like