PowerPivot for SharePoint - Transitioning from a Single Server to SharePoint Farm

Summary

This white paper is a How-to document that provides you with the steps to transition from a single-server Microsoft® SQL Server® PowerPivot for SharePoint® installation to a multi-server PowerPivot for SharePoint farm. As your PowerPivot for SharePoint environment becomes more heavily utilized with more PowerPivot workbooks and more concurrent users, server resources such as CPU, memory, disk, and network become saturated. To alleviate resource bottlenecks, SharePoint itself is designed as a scale-out solution; as more resources are required, more servers can be added to the farm. Therefore, it is important to transition your existing PowerPivot for SharePoint single-server installation into a multi-server farm as resources are required.

Read more...