Patent ID: 7395537

Claim:
A method for administering the workload of a database system as it executes one or more requests, the method including: sorting the one or more requests into one or more workload groups, each workload group having an associated level of service desired from the database system; executing the one or more requests in an order intended to achieve the levels of service associated with each of the workload groups; assigning system resources to the one or more workload groups as necessary to provide the level of service associated with each workload group; monitoring on a short-term basis the execution of requests to detect a deviation from the level of service greater than an short-term threshold and if such a deviation is detected: adjusting the assignment of system resources to workload groups to reduce the deviation; monitoring on a long-term basis to detect deviations from the expected level of service greater than a long-term threshold, and if such a deviation is detected: adjusting the execution of requests to better provide the expected level of service.