Export (0) Print
Expand All

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.

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 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:

Arrow icon used with Back to Top link Top

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:

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.

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 (http://technet.microsoft.com/en-us/library/ff607742(office.15).aspx).

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft