Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all,
Suppose that we have a 4-core pack SQL Server Enterprise license. Do I need to run Power BI Report Server, SSIS ,SQL Server Analysis Services on the same server as SQL Server running on?
Can I deploy Power BI Report Server, SSIS, Analysis Services applications on different machines with higher number of cores?
Solved! Go to Solution.
Hi @mehmet-vrp ,
>>Can I deploy Power BI Report Server, SSIS, Analysis Services applications on different machines with higher number of cores?
As far as I know you can do it. Divide your engine instances and ssas instances to different servers would be a perfect suggestion.
And please refer to https://www.sqlbi.com/articles/optimizing-memory-settings-in-analysis-services/ to optimize the ssas.
And pay attention to If you're creating the report server database on a database server on a different machine, change the service account for the report server to a credential that is recognized on the database server. Please refer to https://docs.microsoft.com/en-us/power-bi/report-server/install-report-server#creating-a-database-on...
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Hi,
From technical point of view, yes I agree with @v-deddai1-msft , is good practice divide instances to different (virtual) machines, at least, separate SQL Server DB (maybe with SSIS), from SSAS and Power BI RS instances.
From licence point of view, as far as I know, you can NOT install any SQL server product to additional machines and additional (physical) cores. Any MS SQL product part (including SSAS , SSIS, RS) must be licenced. I think, if you have MSSQL EE with SA for 4core, you can install to only one 4core virtual machine for all, or you can install on any number of virtual machines hosted on one 4core physical machine.
But I still recommends, divide your instances, at least to MSSQL DB, and to other instances. Additionally you can combine editions, e.g. you can install MSSQL DB on one machine (where is enough cheaper SQL Standard without SA), and SSAS+Power BI on another machine (where you need EE with SA).
Hi,
From technical point of view, yes I agree with @v-deddai1-msft , is good practice divide instances to different (virtual) machines, at least, separate SQL Server DB (maybe with SSIS), from SSAS and Power BI RS instances.
From licence point of view, as far as I know, you can NOT install any SQL server product to additional machines and additional (physical) cores. Any MS SQL product part (including SSAS , SSIS, RS) must be licenced. I think, if you have MSSQL EE with SA for 4core, you can install to only one 4core virtual machine for all, or you can install on any number of virtual machines hosted on one 4core physical machine.
But I still recommends, divide your instances, at least to MSSQL DB, and to other instances. Additionally you can combine editions, e.g. you can install MSSQL DB on one machine (where is enough cheaper SQL Standard without SA), and SSAS+Power BI on another machine (where you need EE with SA).
Hi @mehmet-vrp ,
>>Can I deploy Power BI Report Server, SSIS, Analysis Services applications on different machines with higher number of cores?
As far as I know you can do it. Divide your engine instances and ssas instances to different servers would be a perfect suggestion.
And please refer to https://www.sqlbi.com/articles/optimizing-memory-settings-in-analysis-services/ to optimize the ssas.
And pay attention to If you're creating the report server database on a database server on a different machine, change the service account for the report server to a credential that is recognized on the database server. Please refer to https://docs.microsoft.com/en-us/power-bi/report-server/install-report-server#creating-a-database-on...
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
User | Count |
---|---|
11 | |
9 | |
4 | |
1 | |
1 |