Manually adjust the parallel processing value of SSASCube to Improve Operation Efficiency

By default, when analysisServices processes the selected Cube, the server determines the degree of parallelism used. However, sometimes, the best performance cannot be achieved when the server decides to use multiple threads for processing. For example, it is found that the server has only one CPU 100%while the other servers are idle. In this case, you can manually adjust the concurrency when the server load permits.

By default, when analysisServices processes the selected Cube, the server determines the degree of parallelism used. However, sometimes, the best performance cannot be achieved when the server decides to use multiple threads for processing. For example, it is found that the server has only one CPU of 100% while the other is idle. In this case, you can manually adjust the concurrency when the server load permits.

By default, when analysisServices processes the selected Cube, the server determines the degree of parallelism used. However, sometimes, the best performance cannot be achieved when the server decides to use multiple threads for processing. For example, it is found that the server has only one CPU of 100% while the other is idle. In this case, you can manually adjust the degree of parallelism to achieve optimal performance when the server load permits.

Select "Change Settings ..."

Modify "Maximum parallel tasks", which can be modified according to the server load, for example, 1, 2, 4 ..

For more information, see SQL ServerBest Practices Article.