[SSAS]configuration parameters - moxuemeivip/Microsoft-Analysis-Service-Or-Fabric GitHub Wiki
Some interesting parameters, like ServerTimeout, ForceCommitTimeout, CommitTimeout, ExternalCommandTimeout, CoordinatorExecutionMode.
CoordinatorExecutionMode
Defines the maximum number of parallel operations the server will attempt, including processing and querying operations.The default value for this property is -4, which indicates the server is limited to 4 parallel operations per processor.
ExternalCommandTimeout
Defines the timeout, in seconds, for commands issued to external servers, including relational data sources and external Analysis Services servers.The default value for this property is 3600 (seconds).
CommitTimeout
Specifies how long (in milliseconds) the server will wait to acquire a write lock when committing a transaction.The default value for this property is zero (0), which indicates that the server will wait indefinitely.
ForceCommitTimeout
Specifies how long, in milliseconds, a write commit operation should wait before canceling other commands that preceded the current command, including queries in progress. This allows the commit transaction to proceed by canceling lower priority operations, such as queries.The default value for this property is 30 seconds (30000 milliseconds), which indicates that other commands will not be forced to timeout until the commit transaction has been waiting for 30 seconds. A setting of 0 implies infinite.
ServerTimeout
Defines the timeout, in seconds, for queries. The default is 3600 seconds (or 60 minutes). Zero (0) specifies that no queries will timeout. In Power BI, reports will override the default with a much smaller timeout for each of the queries to the capacity. Typically, it is approximately 3 minutes(225 seconds?).
Some interesting parameters, like HardMemoryLimit, HeapTypeForObjects, MemoryHeapType, QueryMemoryLimit. For Tabular instance: VertiPaqPagingPolicy HardMemoryLimit MemoryHeapType
QueryMemoryLimit
To control how much memory can be used during a query.Specified in percentage up to 100. When more than 100, it's in bytes. Setting a value of 0 means no limit is specified.
IOProcess \ MaxThreads
Specifies the maximum number of threads to include in the thread pool. 0 indicates the server determines the defaults. By default, the server either sets this value to 64, or to 10 times the number of logical processors, whichever is higher. For example, on a 4-core system with hyperthreading, the thread pool maximum is 80 threads.
Process \ MaxThreads
specifies the maximum number of threads to include in the thread pool.
Query \ MaxThreads
VertiPaq \ CPUs
the maximum number of processors to use for tabular queries.