Use max resource granularity to specify the percentage of total memory that Adaptive Server can allocate to a single query. You can set the parameter at the server or session level.
For example, to set max resource granularity to 35 percent at the server level, enter:
sp_configure “max resource granularity”, 35
To set max resource granularity to 35 percent at the session level, enter:
set resource_granularity 35
The value of this parameter can affect the query optimizer’s choice of operators for a query. If max resource granularity is set low, many hash- and sort-based operators cannot be chosen. max resource granularity also affects the scheduling algorithm.
