SharePoint Performance … Presentations Blogs and More

2013

TechNet

SQLIO - Disk Subsystem Benchmark Tool

https://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=20163

http://www.brentozar.com/archive/2008/09/finding-your-san-bottlenecks-with-sqlio/

Plan for Caching and performance in SharePoint Server 2013
http://technet.microsoft.com/en-us/library/ee424404.aspx

more on caching from the cloud engineer
http://thecloudengineer.blogspot.com/2012/06/caching.html

Performance Blogs

Free Whitepaper – Maximizing SQL 2012 Performance for SharePoint 2013
http://sharepoint-community.net/profiles/blogs/free-whitepaper-maximizing-sql-2012-performance-for-sharepoint-20

Performance Presentations

Bill Baer - Tuning SQL Server 2012 for SharePoint 2013: (03) Server Settings for SQL Server
Mod 01: Key SQL Server and SharePoint Server Integration Concepts
Mod 02: Best Practices for SQL Server Database Settings
Mod 03: Server Settings for SQL Server
Mod 04: SQL Server and SharePoint Availability

Database Configuration for Maximum SharePoint Performance (Video, Slide and PowerShell Script)
https://bassplayerdoc.wordpress.com/2013/12/23/database-configuration-for-maximum-sharepoint-performance-video-powershell-script/

2010

Issues Uploading Large Files To SharePoint
http://blogs.technet.com/b/praveenh/archive/2012/11/16/issues-with-uploading-large-documents-on-document-library-wss-3-0-amp-moss-2007.aspx

Sean McDonough from Idera - http://secretsofsharepoint.com/cs/blogs/tips/archive/2010/10/13/tuning-backup-restore-in-sharepoint-2010.aspx

Eric Shupps from Idera
 http://www.idera.com/Downloads/WhitePapers/10-Steps-Optimize-SharePoint-Performance.pdf

Separate User and Database Traffic
Isolate Search Indexing
Adjust SQL parameters
- Provision the major SharePoint databases onto separate physical disks
- Reduce DB Fragmentation – limit use of Autogrowth/Autoshrink
Defragment Database Indexes
Distribute User Data across multiple Content Databases
Minimize page Size
Configure IIS Compression
Take advantage of Caching – Cache Profiles, Object Cache
Manage page Customizations
Limit Navigation Depth

Chris McNulty from Quest - http://www.chrismcnulty.net/SitePages/Home.aspx

Horsepower

don’t forget about paging file 1-2x
WFE Tier 8-16 GB RAM
Virtual OK but watch for other services
APP Tier - 8-12 GB RAM
But do not forget about CPU.  Service like search can be very heavy with search threads.
DB Tier – 8-24 GB RAM
I/O – Not good for Virtual without proper setup

SQL Setup – Very Important

Set growth to 50-100 MB clumps not a percentage – will slow growth
Presize TempDB to 20% of Content DB
Size
Small less than 100 users but can grow if just basic collaboration site
Medium 100 – 10,000 users and 10,000 to 1 Million docs
Large 10,000 + and 1Million+ Docs

Limits

2 GB file size and 30 Million Docs in library

Disk Growth

except 10-20%
Without Maintenance small SP database will grow to 1 TB
Reduce size using EBS/RBS but third party recommend such as Avepoint or Metalogix
RAID 5 or RAID 10

Perf Tools

Dev Dashboard
1/4 to 1/2 second response ok –
Helps to troubleshoot more memory/sql query/web part issues

Logging

WSS Logging Database will grow to about 10-20 GB
ULS view or use views in SSMS of the WSS_Logging Database using T-SQL

Optimize

Blob Cache for static items that only get refreshed every 24 hours (web.config)  IIS 7 and IE 8
IOmeter Open Source testing tool or use Idera tools

2007

http://technet.microsoft.com/en-us/library/ee721075(v=office.12).aspx