Tactical Performance for SharePoint and SQL - References

2014-01-10

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

Comments

Anonymous
January 01, 2003
Very useful, good references! Thanks for sharing

Share via