Transcript DBI406 How are we going to build this? Installation PowerPivot for SharePoint: Single Server Installation PowerPivot for SharePoint: Existing Farm Installation Microsoft SQL.

DBI406
How are we going to build this?
Installation
PowerPivot for SharePoint: Single Server Installation
PowerPivot for SharePoint: Existing Farm Installation
Microsoft SQL Server 2008 R2 PowerPivot Planning and Deployment
PowerPivot for SharePoint - Transitioning from a Single Server to SharePoint Farm
PowerPivot Technical Diagram: PowerPivot Client/Server Architecture
PowerPivot Technical Diagram: PowerPivot Security Architecture
PowerPivot “New Server”
PowerPivot
“New Server”
Move SQL databases out
SharePoint Databases
SharePoint
Web/App Server
Scale-out
LB
SharePoint Databases
SharePoint
Web/App Server
SharePoint
Web/App Server
SharePoint
Web/App Server
SharePoint
Web/App Server
Dedicated servers w/
high availability
LB
SharePoint
Web Server
SharePoint
Web Server
...
SharePoint Databases
SharePoint
App Server
SharePoint
App Server
SharePoint
App Server
...
Capacity planning (long term)
(1)
http://bit.ly/cZOHe0
“New Server”
(2)
‘alias’ the SharePoint RDBMS physically moves the database,
but the SharePoint configuration remains intact
Single
Server
(3)
Single
Server
(4)
‘migrate’ the SharePoint RDBMS so that the SharePoint
configuration sees the database server in its true location
Single Server
Single
Multiple
Server
Scale-out the farm by adding NLB servers;
all servers providing all services
Servers
(5)
WFE
Specialize the farm; add app servers which are tied
to various services (size, scale and configure)
App
Server
App
Server
App
Server
Delegation, Claims, Active Directory
The data connection uses Windows Authentication and user credentials could not be delegated
Delegation, Claims, Active Directory…Oh My!…Aw Crap!
The data connection uses Windows Authentication and user credentials could not be delegated
Testing the Claims To Windows Token Service for different identities
Delegation, Claims, Active Directory….Again?! Frak!
a peek inside
Server, Services, and Components
c2wts/proxy
SharePoint Farm
c2wts
Client
WFE
App
Excel Web Access
Excel Calculation Services
Excel Services Application Proxy
MSOLAP
Excel Web Service
PowerPivot Web Service
Channel
PowerPivot Service
Application Proxy
PowerPivot System Service
Excel Services
PowerPivot Services
SQL
TCP
HTTP
Excel Calc Services
Content
Analysis Services in
VertiPaq Mode
MSOLAP Driver
Data Sources
Rendering the PowerPivot Workbook
SharePoint Farm
c2wts
Client
WFE
App
SQL
Excel Web Access
Excel Services Application Proxy
Excel Web Service
Excel Calc Services
PowerPivot Web Service
Content
Excel Calculation
Services
MSOLAP
Channel
PowerPivot Service
Application Proxy
PowerPivot System Service
Analysis Services in
VertiPaq Mode
Data Sources
Rendering the PowerPivot Workbook
SharePoint Farm
c2wts
Client
WFE
App
SQL
Excel Web Access
Excel Services Application Proxy
Content
Excel Calculation
Services
c:\Program Files\...\OLAP\Backup
Excel Web Service
MSOLAP
Excel Calc Services
PowerPivot Web Service
Channel
PowerPivot Service
Application Proxy
PowerPivot System Service
Analysis Services in
VertiPaq Mode
Data Sources
PowerPivot does NOT require Kerberos
SharePoint Farm
c2wts
Client
WFE
App
SQL
Excel Web Access
Excel Services Application Proxy
Content
Excel Calculation
Services
Excel Web Service
MSOLAP
Excel Calc Services
PowerPivot Web Service
Channel
PowerPivot Service
Application Proxy
PowerPivot System Service
Analysis Services in
VertiPaq Mode
Data Sources
Server Action
SharePoint Farm
c2wts
Client
WFE
App
SQL
Excel Web Access
Excel Services Application Proxy
Content
Excel Calculation
Services
Excel Web Service
MSOLAP
Excel Calc Services
PowerPivot Web Service
Channel
PowerPivot Service
Application Proxy
PowerPivot System Service
Analysis Services in
VertiPaq Mode
Data Sources
Server Action > c2wts
Server Action > c2wts
SharePoint Farm
c2wts
Client
WFE
App
SQL
Excel Web Access
Excel Services Application Proxy
Content
Excel Calculation
Services
Excel Web Service
MSOLAP
Excel Calc Services
PowerPivot Web Service
Channel
PowerPivot Service
Application Proxy
PowerPivot System Service
Analysis Services in
VertiPaq Mode
Data Sources
Server Action
SharePoint Farm
c2wts
Client
WFE
App
Content
Excel Services Application Proxy
Excel Web Access
Excel Web Service
Excel Calc Services
PowerPivot Web Service
SQL
Excel Calculation
Services
c:\Program Files\...\OLAP\Backup
MSOLAP
Channel
PowerPivot Service
Application Proxy
PowerPivot System Service
Analysis Services in
VertiPaq Mode
Data Sources
ImageLoad
Load Balancing
SharePoint Farm
c2wts
App1
App2
Excel Calculation
Services
Excel Calculation
Services
MSOLAP
MSOLAP
Channel
Channel
PowerPivot Service
Application Proxy
PowerPivot Service
Application Proxy
PowerPivot System Service
PowerPivot System Service
Analysis Services in
VertiPaq Mode
Analysis Services in
VertiPaq Mode
• By default, set to round-robin
health allocation
• Testing notes that BP to set to
health-based allocation
• Uses more resources than
round-robin
• BUT, pro-actively evicts
unnecessary VertiPaq dBs
when under memory pressure
Impact of slicers, charts, tables, worksheets
~20
~530
SKUs
Components
Server
HP ProLiant DL360 G7 dual X5650 Processor (1U) with 96GB (12 core)
Storage
8 x internal 300 GB SAS disks
Software
Windows Server 2008 R2 EE OEM, SQL Server 2008 R2 EE VL,
SharePoint 2010 EE VL, PowerPivot SharePoint Integration
Infrastructure
No physical (install in existing rack), Active Directory required
Services
Software technical support
http://h20195.www2.hp.com/V2/GetPDF.aspx/4AA3-3086ENW.pdf
SharePoint SP1 is required for CTP3 (and RTM)
Resources
SQL Server PowerPivot for SharePoint Newsgroup
Professional Microsoft PowerPivot for Excel and SharePoint >
Chapter 9
DBI206 – What’s New in Microsoft SQL Server Code-Named “Denali” for
SQL Server Analysis Services and PowerPivot”, Tues 5/17 @10:15am
DBI471-INT – Tips and Tricks for Troubleshooting a Microsoft SQL Server
PowerPivot for SharePoint Installation”, Tues 5/17 @3:15pm
microsoft.com/sqlserver
http://northamerica.msteched.com
www.microsoft.com/teched
www.microsoft.com/learning
http://microsoft.com/technet
http://microsoft.com/msdn
http://powerpivotgeek.com/2010/04/02/help-c2wts-has-fallen-and-it-cannot-get-up/