Managing resources at query run time

The Resource Manager estimates the resources required for queries to run, and then prioritizes them. You can control how the Resource Manager prioritizes query execution in several ways:

• Set a resource pool's run-time priority relative to other resource pools.

• Change a running query's priority relative to other queries in the same resource pool.

• Move a running query to another resource pool.