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