Tuning for Refresh

Scenario

When a refresh operation is running, system performance is affected and user queries get rejected. You want to reduce the memory usage of the refresh job.

Solution

Set the MEMORYSIZE parameter of the refresh pool to a fixed value. The Resource Manager then tunes the refresh query to only use this amount of memory.