Patent ID: 8082234

Claim:
A computer-implemented apparatus for managing a plurality of database systems, comprising: (a) a domain comprised of a plurality of database systems; (b) a system event monitor and a system state manager, executed on each of the plurality of database systems, wherein the system event monitor is configured to monitor the database system's system conditions and operating environment events and the system state manager is configured to adjust the database system's state; and (c) a multi-system regulator executed on a system, wherein the multi-system regulator manages the domain by: (i) communicating with each of the system event monitors and system state managers on each of the database systems; and (ii) creating a dynamic event on one or more of the database systems within the domain based on the system conditions and operating environment events received from the system event monitor for the database system, wherein the dynamic event created by the multi-system regulator causes the system state manager for the database system to perform an adjustment to the database system's state in order to alter one or more workload priorities or task limits for the database system, wherein the workload priorities define a priority for each workload executed in the database system, and wherein the task limits limit how many tasks run in the database system.