What will be physical architecture for SSAS Tabular model with Sharepoint 2013?


  • 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)


    Saturday, June 21, 2014 1:58 PM


  • Hi Kenny_I,

    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.

    Charlie Liao

    If you have any feedback on our support, please click here.

    Charlie Liao
    TechNet Community Support

    Monday, June 23, 2014 3:21 AM