1. A shared nothing distributed database management system, comprising: a master node; and a plurality of shared nothing nodes, wherein each shared nothing node having a central processing unit that executes concurrently a plurality of queries, each query being implemented by multiple processes, and each shared node comprises: a node state table stored in memory that characterizes the multiple processes implementing each query, the node state table including a target resource consumption rate value and process activity information for each process, and a monitor module executed by the central processing unit that processes information in the node state table, comparing actual resource consumption rate with target resource consumption rate, and dynamically adjusting at successive time intervals during query processing target resource consumption rate values in the node state table for each of said multiple processes in accordance with priority criteria specifying a priority ascribed to a query, and processing the query in accordance with the priority criteria, and wherein the central processing unit utilizes the target resource consumption values in the node state table by providing a corresponding share of central processing unit resources for the multiple processes during each successive time interval.