I have a cube server with 16 virtual core and 64 gb memory . the average usage of memory is around 45% and CPU usage is about 60% max. We have almost 10 cubes on this server.
We are observing whenever we process a cube(any client) the web application which communicates via olap site , queries get stuck . All dashboards for any client hang until we kill the cube processing or it is over.
We were experimenting with multiple setting but any guidance will very helpful as we have restless client on our head.
Tweaking ThreadPool\Query\Max thread from 0 to 160 did helped if cube is not running. Also if we process the cube with max parallel =8 or 16 we are able to query dashboard but slower than expected.
We also add following settting in msmdpump config file
Could anyone please help what is going wrong here and how we can improve it.