Microsoft SQL Server 2008 R2 810-08234 Benutzerhandbuch
Produktcode
810-08234
202
CHAPTER 10
Self-Service Analysis with PowerPivot
SharePoint Farm
Web front end
Application server
PowerPivot
database
database
Analysis Services-
VertiPaq Mode
Excel Calculation
Services
PowerPivot
System Service
Excel Web Access
Excel Web Service
PowerPivot
Web Service
Excel 2010 with
PowerPivot-
View or
create reports
Browser-
View reports
FIGURE 10-12
PowerPivot for SharePoint Architecture
Analysis Services in VertiPaq Mode
To support users without the PowerPivot for Excel client, Excel Services connects to a server
instance of Analysis Services in VertiPaq mode to process PowerPivot workbooks and respond
to user queries . This type of Analysis Services server instance enables in-memory data storage
on a large scale for multiple users and provides rapid processing of large PowerPivot data
sets . Just like the in-memory version of VertiPaq mode on the client, the server version uses
data compression and columnar storage . Unlike a standard Analysis Services instance that
you manage using SQL Server Management Studio, you manage Analysis Services in VertiPaq
mode exclusively in SharePoint Central Administration .
instance of Analysis Services in VertiPaq mode to process PowerPivot workbooks and respond
to user queries . This type of Analysis Services server instance enables in-memory data storage
on a large scale for multiple users and provides rapid processing of large PowerPivot data
sets . Just like the in-memory version of VertiPaq mode on the client, the server version uses
data compression and columnar storage . Unlike a standard Analysis Services instance that
you manage using SQL Server Management Studio, you manage Analysis Services in VertiPaq
mode exclusively in SharePoint Central Administration .
In response to requests for PowerPivot data, Analysis Services loads the cube into memory
where it stays until no longer required or until SharePoint monitoring detects that contention
for resources has reached a threshold requiring action . You can monitor system performance
through usage data, as explained later in this chapter . Analysis Services loads the PowerPivot
data from the workbook as raw, unaggregated data into the cube, compresses the data, and
dynamically restructures the data based on the user’s actions .
for resources has reached a threshold requiring action . You can monitor system performance
through usage data, as explained later in this chapter . Analysis Services loads the PowerPivot
data from the workbook as raw, unaggregated data into the cube, compresses the data, and
dynamically restructures the data based on the user’s actions .
The PowerPivot System Service
The PowerPivot service runs as a service application on SharePoint called PowerPivot System
Service. A service application is configurable independently of other service applications and
isolates service application data . You can install one physical instance of a server but then
create multiple service applications to isolate data at the application level. Another benefit of
the service application model is the ability to delegate administration .
Service. A service application is configurable independently of other service applications and
isolates service application data . You can install one physical instance of a server but then
create multiple service applications to isolate data at the application level. Another benefit of
the service application model is the ability to delegate administration .
The PowerPivot System Service listens for requests for PowerPivot data, connects to Analy-
sis Services to manage the loading and unloading of PowerPivot data, collects usage data,
and monitors system health and availability of Analysis Services servers . It also provides load
and monitors system health and availability of Analysis Services servers . It also provides load