I would like to build SharePoint 2013 based reporting portal with Power View as visualization tool.
I have 300-800 million rows and customer puts priorities in high performance.
Data source is SQL Server database and Flat Files.
What will be recommended physical archicture? Is following good?
-SQL Server database server
-SSAS Tabular application server
-SharePoint 2013 Front-End (multiple if needed)
According to your description, you want to if it's OK to SQL Server database server, SSAS tabular application server and SharePoint 2013 Front-End on different server, right?
As I said in another thread, even though we can install all of them on same physical server, however in the production environment, the recommendation is that install them on different server, it will beneficial to troubleshooting the issue when some
issue occur on the environment. So in your scenario, it Ok to install all the application on different server. Here are some links about requirement to install the application. System requirements for Power View Hardware
Sizing a Tabular Solution (SQL Server Analysis Services)
If I have anything misunderstood, please point it out.
If you have any feedback on our support, please click
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.