Tactical Performance for SharePoint and SQL - References

  • Article

SharePoint Configuration References

Hardware and software requirements for SharePoint 2013
https://technet.microsoft.com/en-us/library/cc262485.aspx

SharePoint 2010 Best Practices
https://social.technet.microsoft.com/wiki/contents/articles/8666.sharepoint-2010-best-practices.aspx?PageIndex=2

SharePoint 2010: Tips for Dealing with Performance Issues
https://social.technet.microsoft.com/wiki/contents/articles/7926.sharepoint-2010-tips-for-dealing-with-performance-issues.aspx

Whitepaper: Database Maintenance for Microsoft SharePoint Products and Technologies
https://go.microsoft.com/fwlink/?LinkId=111531&clcid=0x409

How to Disable the 8.3 Name Creation on NTFS Partitions
https://support.microsoft.com/kb/121007

Enable High Performance power plan
Configuring a Power Plan with Group Policy Preferences
https://blogs.technet.com/b/grouppolicy/archive/2009/09/30/configuring-a-power-plan-with-group-policy-preferences-by-alan-burchill.aspx

SharePoint Cache Settings
https://technet.microsoft.com/en-us/library/cc770229.aspx
https://technet.microsoft.com/en-us/library/cc261797.aspx
https://msdn.microsoft.com/en-us/library/ff647588.aspx
https://office.microsoft.com/en-us/sharepoint-server-help/configure-page-output-cache-settings-HA010120686.aspx
https://office.microsoft.com/en-us/sharepoint-server-help/configure-disk-based-cache-settings-HA010176284.aspx
https://office.microsoft.com/en-us/sharepoint-server-help/configure-object-cache-settings-HA010157783.aspx

 

Tools

Performance Analysis of Logs (PAL) Tool
https://pal.codeplex.com/
https://www.youtube.com/watch?v=8fxEs3pPmNI

Log Parser 2.2
https://www.microsoft.com/en-us/download/details.aspx?id=24659

Using the Performance Analysis of Logs (PAL) Tool
https://msdn.microsoft.com/en-us/library/cc296652(v=bts.10).aspx

Process Monitor v3.05
https://technet.microsoft.com/en-us/sysinternals/bb896645

Process Explorer
https://technet.microsoft.com/en-us/sysinternals/bb896653

ULSViewer
https://archive.msdn.microsoft.com/ULSViewer/Release/ProjectReleases.aspx?ReleaseId=3308
https://www.jeremytaylor.net/2012/07/14/sharepoint-uls-log-viewer-tool-comparison-and-verdict/

Using the Developer Dashboard
https://msdn.microsoft.com/en-us/library/ff512745(v=office.14).aspx
https://blogs.technet.com/b/patrick_heyde/archive/2009/11/16/sharepoint-2010-enable-using-developer-dashboard.aspx
https://blogs.technet.com/b/speschka/archive/2009/10/28/using-the-developer-dashboard-in-sharepoint-2010.aspx

Enable ASP.NET profiling.
https://social.technet.microsoft.com/wiki/contents/articles/7926.sharepoint-2010-tips-for-dealing-with-performance-issues.aspx

How to: Configure ASP.NET Profiler for Load Tests Using Test Settings in Visual Studio
https://msdn.microsoft.com/en-us/library/dd504817.aspx

Debugging, Tracing, and Profiling
https://msdn.microsoft.com/en-us/library/7fe0dd2y(v=vs.110).aspx

Internet Explorer Debugging Script with the Developer Tools
https://msdn.microsoft.com/en-us/library/dd565625(v=vs.85).aspx
https://blogs.msdn.com/b/cbowen/archive/2011/05/25/internet-explorer-9-developer-tools-deep-dive-part-1-introduction.aspx

IIS Log Analysis Tools
https://ilf.codeplex.com/

 

Performance Monitoring for SharePoint References

PowerShell script for monitoring SharePoint WFE's and SQL Server back-ends
https://gallery.technet.microsoft.com/PowerShell-script-for-59cf3f70

Monitoring and maintaining SharePoint Server 2013
https://technet.microsoft.com/en-us/library/ff758658.aspx

Performance Counters Reference (IIS 6.0)
https://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/0a6c9f07-a70c-4c3d-b93d-5dfef593c744.mspx

Windows Server 2003 Performance Counters Reference
https://technet.microsoft.com/en-us/library/cc776490(v=ws.10).aspx

ASP.NET Performance Monitoring, and When to Alert Administrators
https://msdn.microsoft.com/en-us/library/ms972959.aspx

Bottleneck-Detection Counters
https://technet.microsoft.com/en-us/library/cc779038(v=ws.10).aspx

Processor Object
https://technet.microsoft.com/en-us/library/cc786359(v=ws.10).aspx

Memory Object
https://technet.microsoft.com/en-us/library/cc778082(v=ws.10).aspx

Physical Disk Object
https://technet.microsoft.com/en-us/library/cc776376(v=ws.10).aspx

LogicalDisk Object
https://technet.microsoft.com/en-us/library/cc784596(v=ws.10).aspx

Request Execution Time
https://technet.microsoft.com/en-us/library/cc738099(v=ws.10).aspx

Current Anonymous Users
https://technet.microsoft.com/en-us/library/cc783067(v=ws.10).aspx

Connection Attempts/sec
https://technet.microsoft.com/en-us/library/cc783067(v=ws.10).aspx

Current Connections
https://technet.microsoft.com/en-us/library/cc783067(v=ws.10).aspx


Troubleshooting

SharePoint Performance Troubleshooting
https://blogs.technet.com/b/patrick_heyde/archive/2010/05/08/sharepoint-performance-troubleshooting-part-2.aspx

Engaging Microsoft with SharePoint performance issues
https://blogs.msdn.com/b/russmax/archive/2009/01/28/test.aspx

Configuring Performance Monitor Log for SharePoint Performance Issues
https://blogs.msdn.com/b/russmax/archive/2009/05/27/configuring-performance-monitor-log-for-sharepoint-performance-issues.aspx

 

SQL Best Practices

Best practices for SQL Server in a SharePoint Server farm
https://technet.microsoft.com/en-us/library/hh292622.aspx

 

Blogs

Bill Baer
https://blogs.technet.com/b/wbaer/

Mark Russinovich
https://blogs.technet.com/b/markrussinovich/

Russ Maxwell
https://blogs.msdn.com/b/russmax

Patrick Heyde
https://blogs.technet.com/b/patrick_heyde

SharePoint Escalation Services Team
https://blogs.msdn.com/b/spses

Steve Peschka
https://blogs.technet.com/b/speschka

Stefan Goßner
https://blogs.technet.com/b/stefan_gossner/


Books

Mark Russinovich

  • Windows Internals, Part 1
  • Windows Internals, Part 2

Scot Hillier, Mirjam van Olst, Ted Pattison, Andrew Connell, Wictor Wilen, Kyle Davis

  • Inside Microsoft SharePoint 2013

David Mann, Ted Pattison, Andrew Connell, Scot Hillier

  • Inside Microsoft SharePoint 2010