Wednesday, February 12, 2014

Performance of SharePoint Servers

Performance of SharePoint Servers                
Performance issues is all common in SharePoint. Many times it’s a big complainant from users that sites are very slow and not able to do work on SharePoint as expected. Here are some of the STRONGLY recommended methods that should be followed as base on my Experience.

SQL Maxdop setting should NOT be 0
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

SQL TempDB configuration and Optimization.

Database maintenance for SharePoint 2010 Products

Disable Certification Revocation checking.

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.

TCP Chimney Offload 
 By Default in Wind 2008 Servers, this setting is "Automatic", we need to Disable it. "netsh int tcp set global chimney=disabled"

http://support.microsoft.com/kb/951037.

 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.


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 ]

 Use of Disable TCP Chimney on SQL Servers

Please Comment if you need Any Help.Your Feed back is always Welcome.I Am Happy to Help !!!!!

No comments:

Post a Comment

Your feedback is Much Appreciated. I will try to reply to your queries as soon as possible!!Anil Avula

ShareThis

X