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:
The memory request might be estimated by the optimizer if IMPLICIT_PDQ is enabled, as described in Enabling Optimizer-Determined Memory Allocation, or by the active PDQPRIORITY setting.
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 ]