The Memory Consumption during SQL Generation governing setting was added to limit the amount of memory used by the SQL Engine. The justification for this governing parameter is described in the following Strategy Knowledge Base technical note:
KB17205: Multiple custom groups with a number of elements in each group may cause large amounts of memory to be allocated during SQL generation and a large number of SQL passes in MicroStrategy Intelligence Server
This governing setting is located in Developer as a Project Configuration setting under Governing > Result Sets, as shown below:
In Workstation it can be accessed by right mouse click on the project->Properties->All settings
This governing setting only applies to the memory used for SQL generation - and even if this setting not configured to restrict the SQL engine, all memory requests in the Intelligence Server continue to be subject to the Memory Contract Manager configuration. Once this setting has been changed, the Strategy Intelligence Server needs to be restarted, or the project unloaded and reloaded.
When this setting is configured to a value of -1, no limit is applied to the memory used for generating report SQL.
In addition to the Memory Consumption During SQL Generation setting, there is another setting called Memory Consumption during data fetching. This governing setting applies to memory used for data fetching. This setting also impacts data import.
