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

http://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

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

SQL TempDB configuration and Optimization.

http://msdn.microsoft.com/en-us/library/ms175527.aspx

http://blogs.msdn.com/b/joaquint/archive/2011/02/08/sharepoint-and-the-importance-of-tempdb.aspx

Database maintenance for SharePoint 2010 Products

http://technet.microsoft.com/en-us/library/cc262731.aspx

Disable Certification Revocation checking.

http://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.

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.

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

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

http://blogs.msdn.com/b/psssql/archive/2008/10/01/windows-scalable-networking-pack-possible-performance-and-concurrency-impacts-to-sql-server-workloads.aspx

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