Workload Management

Configuring Maximum Memory Allocated to Queries

CREATE/ALTER RESOURCE POOL now support new option MAXQUERYMEMORYSIZE, which caps the amount of memory that a resource pool can allocate to process any query.