I have a unexplained issue that's haunting me for weeks; There is a SSAS cube that's not performing well on any customer server, same sub-par performance on Staging and Production environments, but the same exact cube with the same exact data brought to our internal testing server, which is way less powerful than the customer Production servers, performs better.
The same exact MDX queries performs 50% better on our Test server which is about 25% slower than the production server.
I checked the server settings, the queries created by the application, disk IO performance, reprocessed the Cube, but nothing seems to explain this difference.
The I/O performance would have explained this difference, but this explanation had to be discarded because benchmarking with dskspd showed that their server have faster IO anyway.
Someone has some idea on what I can verify next? I'm running out of ideas :/
Thank you
I would recommend you check power saving mode. Read this article and note how to determine if the CPU is running at top speed.
I would run Geekbench or similar tools to compare single core performance between the servers.