Forum Discussion
SSAS Multidimensional & Tabular on Same Server
I'm not sure in azure, but in on-premise deployment is not problem with two different instances (OLAP and Tabular) on same server. We are using onpremise SSAS server with three instances (OLAP, Tabular and second tabular for workspace) on same server, and all three instances are used from PBIRS farm without problems.
From performance perspective, yes OLAP and tabular use HW resources very differently (OLAP is I/O intensive, Tabular is CPU and Memory intesive), but there is not big difference if are CPU and Memory resources shared in two instances on single server, or on two virtual servers on single HW. In heavy load can be trouble in I/O workloads, because are used very differently and I/O request can be queued, but can be sloved by separated LUNs. In lighter load, I think there no performance problem.
I'm not sure in azure, but in on-premise deployment is not problem with two different instances (OLAP and Tabular) on same server. We are using onpremise SSAS server with three instances (OLAP, Tabular and second tabular for workspace) on same server, and all three instances are used from PBIRS farm without problems.
From performance perspective, yes OLAP and tabular use HW resources very differently (OLAP is I/O intensive, Tabular is CPU and Memory intesive), but there is not big difference if are CPU and Memory resources shared in two instances on single server, or on two virtual servers on single HW. In heavy load can be trouble in I/O workloads, because are used very differently and I/O request can be queued, but can be sloved by separated LUNs. In lighter load, I think there no performance problem.
Thank you so much for this. Having more than one SSAS instance on the same server would be such a critical stop-gap for us to give us some time to plan our move from on-premise to most likely Azure; while getting our teams used to Power BI.
Thank you!
