Bumping up (or tuning down?) performance.
Set this to -5 or -6 perhaps? I'm running a dual-core laptop, so this might improve things. Probably not a good idea if you're using a VPC which appears to use only 1 CPU...
CoordinatorExecutionMode
CoordinatorExecutionMode is a complex SSAS server property that controls the number of parallel jobs that Analysis Server will start. When operations (such as querying and processing) occur in parallel, performance can be significantly enhanced. However, too many parallel jobs on a server can decrease responsiveness to other operations. The CoordinatorExecutionMode property’s value has special meaning as it controls the SSAS coordinator component, as follows:
•
Positive number. Sets the absolute maximum number of parallel jobs per server.
•
Zero. Enables the server to automatically determine the maximum number of parallel operations, based on workload and system resources.
•
Negative number. Sets the absolute maximum number of parallel jobs that can occur per processor (as opposed to a positive number, which is per server).
No comments:
Post a Comment