Managing Resources At Query Run Time

The Resource Manager estimates the resources required for queries to run, and then determines when to run queries and when to queue them.

The Resource Manager also lets you manage resources that are assigned to queries that are already running using either of these methods:

• Setting Runtime Priority for the Resource Pool--Use resource pool parameters to set the run time priority for queries running within the resource pool.
• Changing Runtime Priority of a Running Query--Manually change the run time priority of a running query.