MaximumGlobalQueryMemorySizeMB

Specifies the maximum amount of memory (in MB) that all running queries can consume collectively. If this threshold is exceeded, the query is terminated.

By default, the value of the threshold is 0 (disabled).

Parameter type: optional, dynamic

This parameter configures memory usage monitoring across the following areas:

MDX engine allocations
Intermediate stargates and views for intermediate calculations
Final stargate and view as the result of query execution.

MaximumGlobalQueryMemorySizeMB=n

where n represents the global query memory threshold, in MB.

If the combined memory allocation of all running queries exceeds this threshold, the system stops one or more queries (starting with the latest query) while allowing the rest of the queries to run. The system generates a WARN-level log message.

Tip: You can enable additional logging for troubleshooting purposes by enabling the TM1.Mdx logger at the DEBUG level. DEBUG level logging initiates extra counters and enables more detailed logging about the status of memory measures when running queries, but degrades the performance of queries. Do not enable DEBUG level logging unless you are troubleshooting the system.