1. A shared nothing distributed database system, comprising: a master node; and a plurality of shared nothing nodes, wherein each shared nothing node comprises: a node state table stored in memory that characterizes various statements and multiple processes implementing each statement, target resource consumption rate for each process and process activity information, and a monitor module executed by a central processing unit to process information in the node state table and adjust values in the node state table in accordance with priority criteria specifying individual user priority ascribed to a statement, such that a query associated with a statement is processed in the shared nothing distributed database system in accordance with the priority criteria.