Home | Previous Page | Next Page   Tuning Database Server Performance >

Setting Global Priorities for Queries

Memory-consuming DSS queries are managed by the Resource Grant Manager (RGM) as described in Appendix B. How SQL Queries Are Executed. When the RGM schedules queries, it uses the following factors to determine when to run the query:

Tip:
The RGM cannot determine how much temporary space a query might require and does not manage this aspect of query execution. If a query requires more temporary space for operator overflow than is available, the query fails.

For information about DS_ADM_POLICY, see to Specifying the Admission Policy. Whether DS_ADM_POLICY is set to STRICT or FAIR, the schedule level can determine how soon the query runs.

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]