Assignment of resources to database connection processes based on application information

Abstract

Techniques are disclosed relating to using different process groups to control allocation of execution resources for database connection processes that handle application requests. In disclosed embodiments, a database server receives a request from an application server for one or more database resources, including application information specifying one or more attributes of the request. The database server may assign a database connection process to access a database for the request and assign the database connection process to a process group based on the application information. The database server may assign execution resources based on resource allocation parameters that are associated with the assigned process group. In disclosed embodiments, tenants that are using inappropriate amounts of resources may be identified and requests from the identified tenants may be assigned to process groups whose processes are allowed to use smaller amounts of resources per process than other process groups, which may reduce performance degradation in a database system.