If you anticipate a high volume of requests for PowerPivot query processing in a SharePoint farm, you can add an extra PowerPivot for SharePoint instance to seamlessly add new query and data processing support.
After you install a new instance, you will have additional capacity for querying PowerPivot data or processing PowerPivot data refresh jobs. Optionally, you will have the choice of configuring each server to handle one type of request: query or data refresh.
SharePoint Server 2010 is installed and configured.
SharePoint Server 2010 SP1 is applied and the farm is upgraded.
The existing PowerPivot for SharePoint instance in the farm is SQL Server 2012 (either a new installation or upgraded from SQL Server 2008 R2).
The computer on which you are installing the new SQL Server 2012 PowerPivot for SharePoint server is joined to the farm. The computer and the other servers in the farm must be in the same domain.
Review the following additional topics to understand system and version requirements:
In a multi-server farm, all PowerPivot for SharePoint instances must be at the same version. If you applied service packs or updates to other PowerPivot servers that are already in the farm, the new instance you are adding must be updated to the same version as the existing instance that is already in the farm. The new instance will be unavailable until the updates have been applied.
Use this checklist to add additional PowerPivot servers to a SharePoint farm. These instructions assume that you already have a PowerPivot for SharePoint server in the farm, and that you are adding a second server to handle additional processing load. Except for differences in installation requirements, post-install configuration, and verification, the steps for deploying a scale-out solution are identical to adding a single PowerPivot server to an existing farm.
Determine the service account of the Analysis Services instance that is already in the farm
Each additional instance you install must run under the same account as the first instance. Use either approach to determine the service account:
Run Setup to install a second instance of PowerPivot for SharePoint
Choose an application server that is joined to the farm, but does not have an existing PowerPivot instance on the server.
During Setup, when prompted to specify a service account, enter the account from the previous step. All instances of the Analysis Services service must run under the same domain account. This requirement enables the use of the managed accounts feature in SharePoint that lets you update the password in one place for all service instances of the same type.
Configure the second instance
When configuring a second instance, you only need to provision the local services. All other configuration tasks (such as creating service applications or configuring data refresh) are performed during the initial configuration, and used by subsequent instances that you install.
No further steps are specifically required. You do not need to create service applications, activate features, deploy solutions, or change service application identity. Existing Web applications and service applications will discover and use the new server software automatically.
Optionally, if you installed a second server for the purpose of using one server for queries and one for data refresh, you can configure server instance properties now to specify the type of requests handled by each server. For more information, see Configure Dedicated Data Refresh or Query-Only Processing (PowerPivot for SharePoint).
Verify installation of the second instance
You can use the following steps to verify PowerPivot query processing on the server you just installed.