Transcript Practical tools and techniques for architecting and maintaining high

Practical tools and techniques for architecting and
maintaining high performing SharePoint 2013
environments
Doug Hemminger
SharePoint Solutions Architect, Protiviti
Database
Scaling
Disk IOPS
Disk size
10M items
100M items
Crawl
One DB per 20M
items
Medium/High
SQL IOPS: 10 per 1
DPS
Medium
15GB
2GB log
110GB
50GB log
Link
One DB per 60M
items
SQL IOPS: 10 per
1M items
Medium
Medium
10GB
0.1GB log
80GB
5GB log
Analytics
Reporting
Split when
reaching 100300GB
Medium
Medium
Usage dependent
Usage dependent
Search
Administration
One DB
Low
Low
0.4GB
1GB log
1GB data
2GB log
Title
Url
Storage and SQL Server capacity planning and configuration
(SharePoint Server 2013)
http://technet.microsoft.com/enus/library/cc298801(v=office.15).aspx
SQLIO Disk Subsystem Benchmark Tool.
http://www.microsoft.com/en-us/download/details.aspx?id=20163
How to use the SQLIOSim utility to simulate SQL Server activity on a
disk subsystem.
http://support.microsoft.com/kb/231619
Performance and capacity test results and recommendations
(SharePoint Server 2013)
http://technet.microsoft.com/enus/library/ff608068(v=office.15).aspx
Tuning SQL Server 2012 for SharePoint 2013
http://channel9.msdn.com/Series/Tuning-SQL-Server-2012-forSharePoint-2013
Software Boundaries and Limits for SharePoint 2013
http://technet.microsoft.com/enus/library/cc262787(v=office.15).aspx
Best Practices for SQL Server in a SharePoint Server Farm
http://technet.microsoft.com/enus/library/hh292622(v=office.15).aspx
Please fill out a
session survey for
the HSPUG
Technical
presentation
Scan the QR code
to the right or type
bit.ly/hspugtech141
1
If you submit a
survey, you are