Consideration to Improve Performance for SharePoint 2010 Servers.
Performance of SharePoint 2010 Servers.
Performance is always a big topic of Discussion in Any Organization. No matter how much CPU or RAM you add to the Servers, most of the time Users will complain that the sites are slow, or sudden fluctuations in CPU going consistently high, or Customization issues, SQL Deadlock errors etc... etc.. the list goes on.
Here are some of the very Important things to look at Configuration settings and Troubleshoot certain things, which you may face in various different SharePoint Environments.
Many of the known performance issues like UPA sync is slow from Active Directory or Search crawling has suddenly become slow can be caused due to some SQL or OS related configurations not done correctly or they are not in place at all.
Here are some of the STRONGLY recommended articles that should be followed.
SQL Maxdop setting should NOT be 0
========================================
https://technet.microsoft.com/en-us/library/hh292622.aspx
Set max degree of parallelism (MAXDOP) to 1 for SQL Server instances that host SharePoint Server 2010 databases to ensure that each request is served by a single SQL Server process
Anti-Virus check.
====================
Certain folders may have to be excluded from antivirus scanning when you use a file-level antivirus program in SharePoint
https://support.microsoft.com/kb/952167
SQL TempDB configuration and Optimization.
===================================================
https://msdn.microsoft.com/en-us/library/ms175527.aspx
https://blogs.msdn.com/b/joaquint/archive/2011/02/08/sharepoint-and-the-importance-of-tempdb.aspx
Database maintenance for SharePoint 2010 Products
https://technet.microsoft.com/en-us/library/cc262731.aspx
Disable Certification Revocation checking.
https://support.microsoft.com/kb/2625048
SQL Deadlock errors. Event ID 10016 in logs.
We need to disable following settings on ALL the SharePoint Servers and also SQL Servers. If SQL Server is in Cluster, all the nodes in the cluster also needs to be changed. After making the Changes, Reboot of all the Servers including SQL servers is Mandatory.
1. TCP Chimney Offload https://support.microsoft.com/kb/951037. by Default in Wind 2008 Servers, this setting is "Automatic", we need to Disable it. "netsh int tcp set global chimney=disabled"
2. IP Task Offload. by Default in Wind 2008 Servers, this setting is "Enabled", we need to disable it. "netsh int ip set global taskoffload=disabled". This is also applicable for Fast for SharePoint Server issues. https://support.microsoft.com/kb/2570111
3. NIC settings should be Disabled.
IPv4 Checksum Offload”, “Large Send Offload” and “TCP Checksum offload” [ note: this may require a hard reboot of the servers ]
Why to Disable TCP Chimney on SQL Servers?
Other Tool you are use to Troubleshoot.
Use Developer Dashboard.
==================================
stsadm -o setproperty -pn developer-dashboard -pv ondemand
Comments
- Anonymous
January 01, 2003
This is really good. Another points on caching could be added.