Corrective Database Connection Management

A system comprising:

• a processor;
• and
• a memory in communication with the processor, the memory having computer-readable instructions stored thereupon that, when executed by the processor, cause the processor to:
• receive database connection requests from a plurality of application servers and direct the database connection requests to a database;
• access metrics data including a wait time for each database connection request describing how long the database connection requests waited until being serviced by an open connection at the database;
• determine if at least one wait time of a plurality of wait times occurring during a time interval exceeds a wait limit;
• count, during a time window comprising a series of time intervals, a quantity of the time intervals in which the wait limit was exceeded at least once;
• determine that the database is unhealthy if the quantity exceeds a predetermined count threshold during the time window;
• and
• monitor a health of the database that is determined to be unhealthy.

A non-transitory computer-readable storage medium having computer-executable instructions stored thereupon which, when executed by a processor of a computing device, cause the computing device to:

• receive database connection requests from a plurality of application servers and direct the database connection requests to a database;
• access metrics data including a wait time for each database connection request describing how long the database connection requests waited until being serviced by an open connection at the database;
• determine if at least one wait time of a plurality of wait times occurring during a time interval exceeds a wait limit;
• count, during a time window comprising a series of time intervals, a quantity of the time intervals in which the wait limit was exceeded at least once;
• determine that the database is unhealthy if the quantity exceeds a predetermined count threshold during the time window;
• and
• monitor a health of the database that is determined to be unhealthy.