Hardware and Software Requirements for Analysis Services Server in SharePoint Mode (SQL Server 2012 SP1)

SQL Server 2012 SP1 Analysis Server in SharePoint mode runs outside a SharePoint 2013 farm. Analysis Services server can be installed on a server that is part of the SharePoint farm but the Analysis Services is not dependent on services in the SharePoint in farm.

Analysis Services Installed on a Standalone Server

If you install Analysis Services server in SharePoint mode on a server by itself, then minimum system requirements are based on SQL Server 2012 rather than SharePoint Server requirements.

Hardware and Software Requirements for Installing SQL Server 2012

PowerPivot for SharePoint runs best on new generation business servers that offer higher RAM thresholds and more processing capability. Large amounts of RAM are used to store PowerPivot data in memory. The RAM supports the ability to adapt to structural changes. Extra processors support long running scans of raw, un-aggregated data. The data assumes its structure in a dynamic environment, in response to user-driven data analysis initiated through an Excel client or front-end interface.

Tip

PowerPivot for SharePoint utilizes L2 and L3 caches. To improve performance, consider using Processors with larger L2 and L3 caches.

The following table describes the minimum and recommended hardware configuration:

Component	Minimum	Recommended
Processor	64-bit dual-core processor, 3 gigahertz.	16 Cores
RAM	8 gigabytes of RAM	64 gigabytes of RAM
Storage	80 gigabytes of storage	80 gigabytes or more

The hardware recommendations in the previous section are for a standalone PowerPivot for SharePoint 2013 server that is not part of the SharePoint farm.

For more information on SQL Server licensing, see the following:

• Determining SQL Server 2012 Core Licensing Requirements (https://download.microsoft.com/download/F/F/2/FF29F6CC-9C5E-4E6D-85C6-F8078B014E9F/Determining\_SQL\_Server\_2012\_Core\_Licensing\_Requirements\_at\_SA\_Renewal.pdf).

• How To Buy: Comprehensive licensing information for SQL Server 2012 (https://www.microsoft.com/sqlserver/en/us/get-sql-server/how-to-buy.aspx).

Top

Analysis Services Installed on a SharePoint 2013 Server

If you install Analysis Services server in SharePoint mode on a SharePoint farm server, review the minimum system requirements for both SQL Server 2012 and SharePoint Server at the following links:

• Hardware and Software Requirements for Installing SQL Server 2012

• Hardware and software requirements for SharePoint 2013 (https://technet.microsoft.com/en-us/library/cc262485(office.15).aspx).

The standard SharePoint 2013 hardware and software recommendations are for a web-based document management solution for a workgroup or team. Because PowerPivot processing is data intensive, the standard recommendation is sufficient only if the overall workload is small. For example, less than 100 users or workbooks. A larger PowerPivot deployment requires more computing power.

Additional Information

For information on PowerPivot Hardware Requirements for SharePoint 2010, see Hardware and Software Requirements (PowerPivot for SharePoint and Reporting Services in SharePoint Mode).

For information on SharePoint changes, see Changes from SharePoint 2010 to SharePoint 2013 (https://technet.microsoft.com/en-us/library/ff607742(office.15).aspx).