Sue_H (8/18/2016)
I hope the additional steps include some bench marking and baselines for the system resources when doing this as several other things take a hit when you do this. CPU, context switches, memory usage (not just what's available for SQL), I/O processing etc.Sue
Quick update: we have taken your advice and monitored CPU, server memory usage, etc. We have also started testing out multidimensional with 50 and 100 simultaneous queries to simulate multiple users. However, we have discovered that SSAS multidimensional isn't actually running all of the queries simultaneously. Instead, it is only running 5 at a time. I will assume this is a thread count issue, and I'm starting to research this. Do you have any advice on how we can get more than 5 queries to run at once on SSAS multidimensional?