Workload management of a concurrently accessed database server

A non-transitory machine-readable medium providing instructions, which when read by a processor cause a machine to perform operations, comprising:

• generating a plurality of service classes, wherein each service class is defined by a respective weight and priority that indicates a respective level of resource usage dedicated to execution of each associated database-related action as compared to other database-related actions respectively associated with different service classes;
• creating a context object containing a set of database-workload properties associated with the activity, wherein the activity defines a set of processes associated with at least one database-related action in a database system;
• mapping the context object associated with an activity to a service class from the plurality of service classes;
• and
• simultaneously allocating a set of resources at all nodes in a system based on the weight and the priority of the service class.

A system comprising:

• a session server to register an activity requested through a user in a session;
• a Manager to:
• map a database workload type of a particular session, determine a service class from a plurality of service classes of the database workload type based on a workload table, wherein each service class is defined by a respective weight and priority that indicates a respective level of resource usage dedicated to execution of each associated database-related action as compared to other database-related actions respectively associated with different service classes, and communicate with a set of slave servers executing a resource allocation;
• and
• a slave server to:
• allocate a set of resources at a particular node based on a notification of the Manager;
• map a set of values associated with the priority and the weight received from the Manager to a set of configuration parameters associated with the resource allocation.