Service level agreement (SLA) cognizent self-managing database connection pools in a multi-tenant environment

A method for service level agreement (SLA) cognizant database connection management for multi-tenant environments, the method comprising:

• establishing a single database connection pool in memory of a computer and creating in the single database connection pool, a multiplicity of different database connections to a database;
• partitioning the single database connection pool into different portions, wherein each of the different portions:
• include a subset of the database connections and
• are assigned to each of the different portions of the single database connection pool, a priority level ranging from high to low so that each of the portions of the single database connection pool is assigned a specific priority level that ranges from high to low;
• receiving by the device different requests for data in a database from different application instances executing in a memory of a host computing system supporting a multi-tenant computing environment, the requests issued by tenants of the multi-tenancy computing environment;
• determining by the device a priority for each of the requests;
• selecting by the device for each of the requests a particular one of the portions of the single database connection pool having assigned thereto a priority level that corresponds to the priority of the request;
• and
• processing by the device each of the requests through a respectively selected one of the portions of the single database connection pool;
• wherein:
• the portions of the connection pool are dynamically re-apportioned to include different ones of the database connections according to an anticipated load of requests of a particular priority based on forecasted numbers of priority requests emanating from the tenants.