MaximumSingleQueryMemorySizeMB

Specifies the maximum amount of memory (in MB) that a single MDX query can consume. 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.

If a query's allocated memory exceeds this threshold, the system stops that query and generates a WARN-level log message.

MaximumSingleQueryMemorySizeMB=n

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

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.