multidimensional
1 TopicSSAS Multidimensional & Tabular on Same Server
Hello, We are planning a migration of our SSRS server to an on-premise Power BI Report Server with the longer term plan to migrate everything to Azure & Power BI Service. There is guidance out there to not install SSAS Multidimensional & Tabular on the same server for performance reasons as they allocate and use the hardware differently, etc. My question is: What about for lighter workloads? We have a low user count. Over the past 2 years our SSRS server has served: 40 unique users per month at peak. On average 7 users per day with a peak of 21 on one of those days. Our data volume is quite low: Multidimensional cubes = 2GB. Tabular Model = 500 MB. Most of the rest of the reporting is via T-SQL procedures. If this is seen as a lighter workload scenario, could it be appropriate to install two instances of SSAS, one in each mode to buy time to then plan to move to the cloud? Or do you think it would make all performance horrendously slow, including any SSIS jobs? Thank you for any insights you may have. BradSolved2.9KViews0likes2Comments
