Transcript OSP313: Scaling Document Management on Microsoft

OSP313
Performance and capacity test results and recommendations
SharePoint Server 2010 capacity management: Software boundaries and limits
Master Drop
Site Collection
Archive Site
Collection 0
Content DB 0
200GB
Content DB 0
1TB
LEGENDS
Logical
Logical Unit
Unit Number
Number (LUN)
(LUN)
Master
Master Data
Data File
File
Secondary
Secondary Data
Data File
File
Log
Log File
File
Index File
MS Word Document
MS Excel Document
MS PowerPoint Document
HTML File
Local FILESTREAM
Application
SQL Server
Application
Database
RBS Client
Library
RBS Aux
Resources
Provider
Library
BLOB Store
(File Group
And tables)
Remote FILESTREAM
Application
RBS Client
Library
Provider
Library
SQL Server 1
Application
Database
RBS Aux
Resources
SQL Server 2
BLOB Store
Database
BLOB Store
(File Group and tables)
Debunked
Can I use
Disk in Case
Yes
DASD
Yes
SAN
Yes
NAS
Only through iSCSI with remote filestream provider
Unstructured Data
Solution
Dedicated BLOB Store
File System or File Share
BLOBs in Database
Advantages


Lower cost per GB at scale
Scalability & Expandability
 Low cost per GB
 Streaming Performance
 Integrated management
 Data-level consistency
Disadvantages



Complex application
development & deployment
Separate data management
Enterprise-scales only
 Complex application development
& deployment
 Integration with structured data
 Poor data streaming support
 File size limitations
 Highest cost per GB


EMC Centera
Fujitsu Nearline
 Windows File Servers
 NetApp
 SQL Server VARBINARY(MAX)
Example
SP2010 Farm
WFE FAST
Query SSA
SQL 2008 Cluster
FAST
FAST
WFE FAST
FAST
FAST
Query SSA Content SSA Content SSA Content SSA Content SSA
Crawl DB
SharePoint DB
FAST Search for SharePoint 2010 Farm
FAST ADM
Admin
Query
CD
ID
8 Docprocs
FAST IX
FAST IX
FAST IX
FAST IX
FAST IX
FAST IX
FAST IX
FAST IX
FAST IX
FAST IX
FAST IX
FAST IX
Index (Search) Index (Search) Index (Search) Index (Search) Index (Search) Index (Search) Index (Search) Index (Search) Index (Search) Index (Search) Index (Search) Index (Search)
CD
CD
CD
Web Analyzer Web Analyzer Web Analyzer Web Analyzer Web Analyzer Web Analyzer
ID
ID
ID
20 Docprocs
20 Docprocs Web Analyzer 20 Docprocs
20 Docprocs
20 Docprocs
20 Docprocs
20 Docprocs
20 Docprocs Web Analyzer Web Analyzer Web Analyzer
20 Docprocs
20 Docprocs
20 Docprocs
20 Docprocs
FAST SRCH FAST SRCH FAST SRCH FAST SRCH FAST SRCH FAST SRCH FAST SRCH FAST SRCH FAST SRCH FAST SRCH FAST SRCH FAST SRCH
(Index) Search (Index) Search (Index) Search (Index) Search (Index) Search (Index) Search (Index) Search (Index) Search (Index) Search (Index) Search (Index) Search (Index) Search
QR Server
QR Server
8 Docprocs
8 Docprocs
8 Docprocs
8 Docprocs
8 Docprocs
8 Docprocs
8 Docprocs
8 Docprocs
8 Docprocs
8 Docprocs
netsh int ip set global taskoffload=disabled
http://technet.microsoft.com/en-us/sharepoint/ff601870.aspx
http://technet.microsoft.com/en-us/library/cc262787.aspx
http://www.bing.com/search?q=LargeScaleDocRepositoryCapaci
tyPlanningDoc.docx
http://northamerica.msteched.com
www.microsoft.com/teched
www.microsoft.com/learning
http://microsoft.com/technet
http://microsoft.com/msdn