Patent ID: 8099411

Claim:
A method of managing workloads in a database system deployed in a computer system, comprising: specifying a target consumption for a workload that specifies a target computer system resource consumption; specifying an averaging interval over which an average of system resource consumption of the workload is monitored internally in the database system; calculating, at a pre-defined interval, a current system resource consumption of the workload; calculating, at the pre-defined interval, the average of the system resource consumption over the specified averaging interval for the workload; calculating at least one of a concurrency level and a rolling average concurrency level, wherein the concurrency level specifies a number of queries of the workload that may be concurrently executed that would drive the current system resource consumption to the target consumption, and wherein the rolling average concurrency level specifies a number of queries of the workload that may be concurrently executed that would drive the average of the system resource consumption to the target consumption; and adjusting a concurrency throttle assigned to the workload that specifies a number of queries of the workload that may be concurrently processed in the database system based on at least one of the concurrency level and the rolling average concurrency level.